How to avoid this problem with linked records

Thanks in advance, attached DB schema and issue.


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.

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.

2 Likes

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.