Help

Re: Input from multiple tables

Solved
Jump to Solution
649 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nik
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

@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.

Screenshot 2023-11-02 091220.png

 

Catalogue Lookup Table. Converts product names into SKUs

Screenshot 2023-11-02 091302.png

 

Product Inventory Table. Converts SKU's into whether product is in stock or not.

Screenshot 2023-11-02 091316.png

 

Let me know if that works for you! 

See Solution in Thread

3 Replies 3
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

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
8 - Airtable Astronomer
8 - Airtable Astronomer

@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.

Screenshot 2023-11-02 091220.png

 

Catalogue Lookup Table. Converts product names into SKUs

Screenshot 2023-11-02 091302.png

 

Product Inventory Table. Converts SKU's into whether product is in stock or not.

Screenshot 2023-11-02 091316.png

 

Let me know if that works for you! 

Nik
5 - Automation Enthusiast
5 - Automation Enthusiast

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