Conditional Drop Down between four tables (in a square relationship)
The relationship between the tables is:
SubContract -< SubContract Lines
SubContract - < Invoice
Invoice - < Invoice Lines
SubContract Lines - < Invoice Lines.
Each sub-contract will have a number of SubContract Lines of detail against which we need to track expenditure against each. The expenditure coming in the form of invoices.
When invoices come in they will have multiple detail lines in them, that will correspond to the SubContract Lines, and hence we need to be record them against the relevant sub-contract line.
So when creating an invoice I want to be able to select the contract. This I can do easily.
Then when I add an invoice line to the invoice, I want a dropdown that allows me to select from the lines in the corresponding contract.
Cant his be done natively? Or is there a better way to do this?
Thanks in advance.