+4Hi,
I am trying to create a table that has one input field - the name of a product. This field is used to look up the article number of the product from another table - the catalogue.
I then want to use the article number to look up data from a third table, which will tell me whether this product is in stock or not. I don't want to use a second input field to keep the use of the table as simple as possible.
Can you help me out with a solution to my problem?
Thank you for your help in advance.
Best answer by Arthur_Tutt
@Nik11 Here's a sample table structure with the inventory lookup:
Product Lookup Table. Simply search for product name and it returns whether in stock or not.
Catalogue Lookup Table. Converts product names into SKUs
Product Inventory Table. Converts SKU's into whether product is in stock or not.
Let me know if that works for you!
+19Hey @Nik11 can you share some screenshots of your current setup / table structure? Helps us to better visualize what you're trying to achieve. Thanks!
+19@Nik11 Here's a sample table structure with the inventory lookup:
Product Lookup Table. Simply search for product name and it returns whether in stock or not.
Catalogue Lookup Table. Converts product names into SKUs
Product Inventory Table. Converts SKU's into whether product is in stock or not.
Let me know if that works for you!
+4@Nik11 Here's a sample table structure with the inventory lookup:
Product Lookup Table. Simply search for product name and it returns whether in stock or not.
Catalogue Lookup Table. Converts product names into SKUs
Product Inventory Table. Converts SKU's into whether product is in stock or not.
Let me know if that works for you!
@Arthur_Tutt thank you for your quick response! This solves my problem 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.