Work with contracts that have more than one project and projects that have more than one contract.  I've created and using a junction table, where I'm having trouble is, when an invoice for the contract is received, the payment is for one project or the other or split.  How do you record the invoice information when it's only tied to the contract?  Tried connecting it to the Projects table as well but that messed up entry on a form.

---

Reply from Alex Hedley:

Do you have an example with some sample data to get a better idea of what you want to achieve.