Help

How to avoid this problem with linked records

Topic Labels: Base design
Solved
Jump to Solution
1105 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jose_Martinez1
5 - Automation Enthusiast
5 - Automation Enthusiast

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
augmented
10 - Mercury
10 - Mercury

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
augmented
10 - Mercury
10 - Mercury

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.