How do I combine the products of an invoice into a single invoice?

[kkid]

I am practising making relational databases as I haven't used them before.



The mock database I am creating is based around a cleaning company.

I am trying to make a form which will display all of the bookings a certain cleaner has in the future. I want it to be able to display a booking along with the services (Windows cleaning, vacuum cleaning etc...) the customer wants.

At the moment, it is displaying each service (Window cleaning, vacuum cleaning etc...) as a seperate result on the form and it is not combined. They both have the same booking_ID from the booking table. How can I combine them?



It is far easier to understand what I mean by looking at the database (Attached). Take a look at the form I have created and then click the > arrow at the bottom to see what I mean.

Test DB.zip

[June7]

Use form/subform arrangement for data entry edit.
http://office.microsoft.com/en-us/ac...010098674.aspx

Use report with Grouping & Sorting functionality to output data.