I'm new to Airtable, but I'm learning fast. I have a table called "Parts" with names and current quantities of parts. I want to create a table to keep track of part orders. I see you can select multiple records from a "link to another record" column, but I need to be able to identify that I ordered multiple of a certain part in an order. However, you can only add a record once to in a "link to another record". How should I go about implementing this?
Three tables would be needed in this case.
1. parts (part ID, part name, etc.)
2. orders (order ID, date, etc.)
3. order details (order details ID, order ID, part ID, quantity, etc.)
Orders and order details are linked one-to-many.
Order details and parts are linked one-to-one.
This may seem complicated, but this way makes tallying easier.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.