If a client has more than one car, how to have one car's data printed to the invoice
I'll word this the best I can and if there are additional questions I'll be happy to answser them. I've built a ADB for an Auto Repair Shop. I've added Customer Form, Auto Fields with a continuous form nested in the Customers form, as shown (Picture 1). On the "Orders" form (Picture 2) I have added fields where the automotive data needs to be re-entered, as a work around until I can figure out the correct way to have the correct data printing on the invoice (picture 3) without having redundant data. If it were just one car per client, that would be easy enough, but many clients have more than one car and I need that car on the invoice. A dropdown would be a nice way to go (combo box) maybe using a Concatenation of all the car data in a query? I'd like to make it easier for the owner to enter data. Thank you so much in advance, I really appreciate your help. Thanks to this group, I've nearly completed this database. Best Regards, Tony. Edit: I created a query for the automobiles and dropped the query into the order/repair form. Now I'm able to see the cars on the report but I see all of the cars of the customer, and I would like to filter only the current car being worked on. See pic4. Thank you again for any help.