I feel like I am digging myself into a deep hole. I have created a db that keeps track of repair service that is performed on customer vehicles. However, my queries are not giving an accurate portrayal of customer invoices.
If you click frmMenuMaster and then click “Customers – Add/Edit” you will bring up the form that keeps track of customer contact data and the customer’s vehicles. If you click a vehicle and then click “Print Repair Order” you will bring up a form that should display all of the repair orders for that particular vehicle. You will note that if you go to Jerry Spencer, you will see that none of his vehicles are displayed, despite the fact that he has a number of repair orders However, if you close frmCustomerContactData and go back to the “Switch Board – Main” and click “View Customer Invoices”, a report is opened that displays customer name, vehicle and date of repair for vehicles that have had a service performed on them. The first seven records appear to be information relative to invoices for services performed on George Hopkins’ vehicles; however, records 60, 66, and 67 belong to Jerry Spencer, which you will be able to see if you click one of the record numbers and click “Open Invoice”. And records 53, 58 and 68 belong to David Robbins. Consequently, although George Hopkins appears to have 7 invoices for vehicles repaired, he only has one: Record 59. And although David Robbins only appears to have three invoices, he really has 6.
This has been baffling me for quite some time so I hope that I can put it to rest with this question.
Thank you for your help in advance.