Hi all,

I have created the attached database to show you what sort of thing I am trying to acheive.

A customer will call us each day with 1 to say 10 bookings, these bookings are then allocated to an Invoice and Invoiced at the end of each month.

The invoice consists of many bookings for a each customer.

The attached is only a guide to make sure i am heading in the right direction.

Thanks

Simon