I am also having trouble with this concept. Would you mind explaining in greater detail using the following example?
Parts: engine, tire, frame, rim, window, lug nut, radio, trailer hitch
Wheel: Contains rim(1), tire(1), lug nut (5)
Car: Contains engine(1), window(4), wheel(4)
Truck: Contains engine(1), window(4), wheel(4), trailer hitch (1)
Garage: Contains car (2), truck (1)
If I’m designing a table that contains a Car, it has one field which is a link to parts which has the engine and windows in it and another field which contains a link to the wheel (4) which has the tire, rim, and lug nuts (5) in it. This is a simple example which gets much more complicated the more types of sub-assemblies that are in my database. I really don’t want to have to add 20 lug nuts from the Parts table to my Car table. I want to add 4 wheels. I can do this with any spreadsheet so I’d imagine I should find a way to do it with AirTable. If not, I’m out.
Expanding on the above example: Let’s assume the Car table has a Parts field and a Wheel field. How do I pull the cost of the Parts (engine & windows) and also the cost of the wheels (4 x cost from Wheel table) into a single Cost field?
I wonder if the answer is in a report or view.