First, I have the following tables:
activities:
ID |
Guide |
Garden |
activityDate |
comment |
gardens:
activeGuides:
I have form or a query that is based on the following SQL query:
Code:
SELECT activities.ID,
[first_name] & ' ' & [last_name] AS Guide,
gardens.garden_num,
activities.activityDate,
activities.comment
FROM activities
INNER JOIN activeGuides ON activities.guide = activeGuides.ID
INNER JOIN gardens ON activities.garden = gardens.ID
The problems happens when I try to change the garden_num of a certain activity, not only that garden_num changes, but to other activities!
I do not see any constancy I could point as to which activities do change or which do not.
I'd be grateful if someone could point me out to how to edit only one activity.
Thanks!