Hi Duane:
Yes, I have a table to set up the tag itself and then a junction table of Contact ID and Tag. I can go into the table directly and add as many tags per ID as I wish but the form overwrites.
Thanks
On Apr 22, 2015, at 6:06 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote: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
__._,_.___
Posted by: Jan Hertzsch <jan.hertzsch@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar