2 files, same portal = complex relationships

[the_moto]

Help,

I have 2 files: 1 called "Jobs" that contains specific job information. Including a portal to a file called "jobItems". No problem here. The other file is called "Invoice" and contains billing information for each job, also with a portal to the same file called "jobItems" where a user will check a box when the itam is invoiced.

So, the 2 seperate files need to display the same portal. At one point, i got it to work, but was not able to create multiple invoices for the same job with the same set of "jobItems" and the same job number.

Here's what I think is involved relationshipwise:

Jobs - jobItems = 1 - many

Jobs - Invoice = 1 - many

Invoices - jobItems = many - many

I hope all this is clear.

Thanks

(We don't allow duplicate posts. Please answer this thread in "Relationships". -bd)