Hi

I have a 4 databases test application, Orders, Clients, Items and Products. Each have only one Form. Items has a subform, a relational link to Products by Product_ID. This part works OK. For test purposes, I created an LE called XLU_Product_Description on the Items form. This LE contains the following code:

XLookup("c:\Sesame\Data\Samples\Products.db" , Product_ID , "Product_ID" ,"Product_Description" , XLU_Product_Description)

The code is to execute "On Form Entry". It Tests OK and Reconciles properly but nothing happens in Sesame Database Manager. I see no product description when in Search Mode and using F10 to browse records. I'm stumpped. I would appreciate any help.

TIA

Serge

Hi Jack

Thanks for thr reply.

I checked the LE property. It is bound to !XLU_Product_Description.  I tried to change the target name consequently but  the program would not compile. I really don't know  what to try next!

Regards

Serge

Quote:


Your code looks fine. I am wondering why have you put it in On Form Entry Event? Normally you will have such code on Element Exit Event of Product ID element. As it is now, you would not see the product description after entering the Product ID while adding data.  In order to view updated data, you may place this code on form entry event but that would be in addition to the one mentioned earlier. Does product ID field have proper Product ID when you enter the form while searching?

X-Family commands do not work in preview mode. Does your command work when you add a new record? When you enter Product Id and exit the field, does product description display?

Are you getting a value from @error?

Quote:


We have tendency to use terms Database and Application interchangably. It is not so. In Sesame, one application can and usually contain many databases. In the application where you have subform contain at least two databases.

Since you have Item Form with Subform Product, I believe Item and Product databases belongs to the same application.

If this is the case, the xlookup of the product ID is from the same application but from Product database. (Product form)

XLookup  (@fn ,  Product_ID ,  "Product!Product_ID" ,  "Product_Description" , XLU_Product_Description)

Where "Product" is the name of the form.

Please also make sure that you are not operating in Preview mode in which Xlookup commands do not work.

If you have all four databases in the same application, you can repalce the application name with @fn.

XLookup (@fn, Product_ID, "Product_Form!Product_ID", "Product_Description", XLU_Product_Description)