I got the tables as follow:
Table 1: Product Name, Product Category
Table 2: Item Name, Product Name
I would like the Product Name in Table 2 to link to Product Name in Table 1, with condition where the Product Category is A.
Can I know how to set th...
Table 1: Item Name, Product Name
Table 2: Product Name, Product Category
In Table 1, the Item Name is key in by user, and then Product Name will be listing that allow user to select, and now I want it to be a list of product name with product...
Good day to you Justin,
Thanks a lot for your reply. By the way, does it mean that in order to get the listing from another table, I will create one field with Link to another record, and then create another field for the lookup?
Is it possible that ...