Hello,
I am attempting to create a vehicle maintenance database and I am running into an issue I am hoping someone can help with. When I add a service record it seems to be adding the record for every vehicle in the vehicle table. In Access I can create this same relationship as a one to one without issue. I have attached a copy of my database for you to view and comment on. Thanks
Vehicle_Maintenance.odb
Hello,
What is needed here is a connection between the tables using the ID and using a Left Join to add data to appropriate records:
You can select Vehicle_ID in tblService and drag that to the one in tblVehicle. This sets the connection. Then right mouse click on the connecting line and select Edit... to bring up the Join Properties dialog.
When I right click on the connecting line and select edit I get a Relations window with Tables Involved, Fields Involved, Update Options, and Delete Options. I don’t see a left join option. I am on version 6.2.8.2.
You need to Edit the Query. That is what is displayed. You are looking at the Relationships dialog which looks nothing like the displayed image. Joins are done in SQL (queries).
Note the top line of the image to the far right - it states Query Design.
SQL on its’ own is extremely flexible and can overcome the need to use macros if understood properly. SQL in queries does not automatically consider what relations may already be established (although data integrity is maintained in other statements such as UPDATE etc.) - that is presumptuous. I personally try to stay away from using this GUI and instead typically do the editing in SQL View.
Thank you Ratslinger for the assistance. I got it working after reading your comment regarding query design. Much appreciated!
