Join Tables - Invoices & payments

[Answers]

Most of the databases I create have been for scheduling, services, jobs. Generating stats etc.. Now I have an invoicing database I'm working on. Invoices, parts, customers all work well. Now I need to add a payment system so they can apply payments to multiple invoices. I created a payment table, to store check #, amount, reference. then I created a join table to hold the invoice# and payment id to break down the many to many relationship. I'm having a brain freeze trying to create the layout. So I can take one payment of say $500 and apply it many invoices. I just need an example file so a light bulb goes off. Can anyone point me in the right direction?

any help is greatly appreciated!!

[Josh Ormond]

Check this out...it got me moving on a solution.

[AgentsSka]

Is it possible you may post your solution if you improved on the one you linked to?