1 of 1 people found this helpful
Create the Value List in the file where the product database resides. Depending on the number of products you might prefer to make it a list showing the product's primary_Key field as value one and Product_name as field two. Have it sort on the product_name but store the primary_Key.
In the file where the selection will occur for the Invoice or Order, create a Value List which uses the values from the list in the other file. Format it as a Drop-Down Menu item.
You can use this show the list of product_names but it will actually enter the product's Key. YOu can then set the other values in the ordered item based on lookups or auto-enter calcs with that relationship.