many to 1 relationship
1 Topic
All I need is to be able to choose a car from the customers list of cars
I've designed a database for an auto repair company and everything works great except for one issue with the invoice. The autoT Table is set to a customer in the CustomerT table, and in the AutoT Table are a list of the customers car(s) and the work orders in the OrdersT table. The AutoT form is a nested form on the OrderF form. The problem that I'm having is that many customers have more than one car, and I need to be able to create a way to select "one" of the cars from the list of cars, when one of the cars have returned for additional repairs at a later date. I'll attach the database as well as the photos. All I need is to be able to choose a car from the customers list of cars and to have it appear on the report/invoice without the other cars appearing. Thank you in advance.Solved2.2KViews0likes10Comments