Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to avoid this problem with linked records

Topic Labels: Base design
Solved
Jump to Solution
358 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Thanks in advance, attached DB schema and issue.Captura de pantalla 2021-11-22 a las 14.20.29 p. m.
Captura de pantalla 2021-11-22 a las 14.19.29 p. m.

1 Solution

Accepted Solutions

It appears that you can have multiple Orders for a given Contract.

image

If that is the desired relationship, then you want Contract Items linked to Order, which would make it your new Order Items. Those former Contract Items (now Order Items) are connected to a Contract through Order.

image

If you want to see all Items for a given Contract, you just have to set your group appropriately in Order Items.

Sorry if this is wrong, I’m probably assuming too much.

See Solution in Thread

1 Reply 1

It appears that you can have multiple Orders for a given Contract.

image

If that is the desired relationship, then you want Contract Items linked to Order, which would make it your new Order Items. Those former Contract Items (now Order Items) are connected to a Contract through Order.

image

If you want to see all Items for a given Contract, you just have to set your group appropriately in Order Items.

Sorry if this is wrong, I’m probably assuming too much.