I'm not too sure how to approach this issue but I've been battling with a relationship cycle and I'm unsure how to get myself out of it. What I have are the following tables:
Sales (all sales transactions are stored here)
First off a sales contract is issued, from there the user can either create a sales freight contract (there can be multiple freight companies associated to one sales contract) or the user can start entering sales transactions. The order doesn't matter. The issue is that at some point (for tracking purposes) each individual sales transaction needs to be assigned to a particular freight contract under the parents sales contract. This leaves me in a relation loop and I'm stuck. I can't seem to find a way to have each sale transaction associate themselves to the proper freight contract in a portal all while having proper freight calculation totals.
I hope I'm not being to general, help would be greatly appreciated!