Input from multiple tables

[Nik]

Hi,

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.

[Arthur_Tutt]

Hey @Nik can you share some screenshots of your current setup / table structure? Helps us to better visualize what you're trying to achieve. Thanks!

[Arthur_Tutt · Accepted solution]

@Nik 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! 

[Nik]

@Arthur_Tutt thank you for your quick response! This solves my problem 🙂