DBlookup for populating fields
Posted on 2006-05-15
Hey Experts, this should be simple but I can't figure it out....
I have a form "Order Items" in Orders DB, I'm trying to set it up so that when the user selects a vendor (productsdb) the next picklist shows the products that vendor has to offer, here's the catch Vendors is one form in the products db while Products is a different form, the vendor and product db are tied by a vendor ID number which exist in both forms. Currently I have field ProdcutType which has this formula: @Sort(@Unique(@DbColumn(orllnd01;"":"Products.NSF";" Product Lookup ";1))) this them fields the Item field via this formula: @Sort(@DbLookup( orllnd01;"":"Products.nsf"; "Product Lookup"; POType;2 )) works great but it displays all products I want to be able to isolate the products by vendor. I also need to grab all the vendor information and populate a vendor information fortion of the Order Items form for printing purposes.....Ideas?