I have the following problem.

I have a people file with customers and one order file and one line_items.

With this setup can I add one customer to one invoice, but I need to add more then one customer to the same invoice it could be 100 different customer in one invoice.

For example, a hotel invoicing system:

A group with a group leader called

You need a join file between people and invoices, beause this is now a many-to-many relationship.

But I have to express my doubts about the need for adding more than one customer at all.

Thanks for your input. I actually have a file that is connecting the invoices together with the customers and it is working BUT, the whole process is complex moving a lot of information between files.

Problem two in this is that it could happen that the customer paying the invoice