hi everybody im new in access and I need help with an update query
I have a
Table
Pet data Owner Reservation (the fields are add from a form)
- ownerphone - ownerphone -ownerphone
- dogname - name - dogname
- vax1 - ownerlast name - vax1
- vax2 - vax2
-ownerlast name
pet data connect to owner with ownerphone and dogname with ownerlastname
owner connect to reservation with ownerphone
now a owner can have multiple dogs
in the reservation table a dog can have multiple reservation
what I want and need that if in the pet data I have to change the vax1 date after I click on the exit bottom the reservation field vax1 update.
I made it with this sql
UPDATE Reservations LEFT JOIN [Pet Data] ON Reservations.HPHONE = [Pet Data].HPHONE SET Reservations.[DHLP-P,DRCP] = [PET DATA].[DHLP-P,DRCP], Reservations.[K-9 Flu] = [PET DATA].[K-9 FLU];
the problem that I have is if a owner has 2 dogs the reservation vax1 pick up the 2nd dog info instead only pick up the data from the 2 different dogs.
hope somebody will help me understand because I have never done an update query