Jan,
Do you have a separate junction table for person/tags? This table would contain one record for each tag for each person. If a person was tagged as Hostile and Volunteer, there would be 2 records in the junction table.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Apr 2015 14:54:45 -0700
Subject: [MS_AccessPros] Form input with multiple values for a field
I am inputting data using a form with 3 sub forms. One is for tags. (Attended fundraiser, Volunteer, Hostile, Donor, etc). I notice that when I input to the form, it overwrites the tag that is in my "status" table. I don't want to overwrite, I want to add tags to the record.
How can I do this?
Thanks
Do you have a separate junction table for person/tags? This table would contain one record for each tag for each person. If a person was tagged as Hostile and Volunteer, there would be 2 records in the junction table.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Apr 2015 14:54:45 -0700
Subject: [MS_AccessPros] Form input with multiple values for a field
I am inputting data using a form with 3 sub forms. One is for tags. (Attended fundraiser, Volunteer, Hostile, Donor, etc). I notice that when I input to the form, it overwrites the tag that is in my "status" table. I don't want to overwrite, I want to add tags to the record.
How can I do this?
Thanks
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar