HI Richard!

My dad is a mechanic and asked me to create a database for his customers and their cars. I created an Invoicing system by combining elements from TechHelp videos Invoicing, Customer Pricing, Customer Code and Custom Sequential Number. Works perfect.

Customer Form has subforms for orders and account receivables, and a Command button to take him to the Order Form to see the full details.

One customer (a car rental) brought 3 cars to service. My dad doesnt want to create a separate invoice for each car, but 1 invoice for all 3 cars.

But that created a problem. Hes happy with the CUSTOMER Form, But he wants the same for the CAR form. He wants to open the Car Form, and in a subform see the services done for each individual car, with the Invoice Number and Invoice Date.

On the Order details form (Description/Qty/Unit Price/Amount) I tried adding a combobox to the left of the Description, to enter the Car. It created 2 big messes, first the combo box lists ALL the cars in the database, and second I ended up with 3 duplicates of all the records in the order table. I had to delete everything a restore a backup database.

Is theres an easier way to do this? If yes have you covered it in a lessor or TechHelp video?