Bharat,
//Trucks.db, with TruckLines.db as a subform of the Trucks.db //Inventory.db A dispatcher needs to build a picklist of products to load onto a delivery van. So they create a new record in Trucks, and enter the items that need to be picked in the subform TruckLines. I want him to input the ItemNum, and then have the programming find the matching ItemNum in Inventory.db and have the product description pulled from the Inventory!ItemDesc field and plugged into the ItemDesc field on the TruckLines subform (sales reps navigate with part #'s, but delivery drivers usually rely on the description field of the item).
//code (on element exit, entered on TLItemNum)
IF @add and TLItemNum <> "" then { XLOOKUP (@fn, TLItemNum, "INVENTORY!ItemNum", "ItemDesc", TLItemDesc) }
fyi, here is the programming I have in my QA Trucks database (STOCK = Inventory.db, and "PART #" = ItemNum) ... >#50: XLOOKUP ("STOCK",#50,"PART #","DESC.",#51,"LOCATION",#52); GOTO #11
|