Help creating a table for part orders

Topic Labels: Base design
382 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1
11 - Venus
11 - Venus

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.