Hopefully you guys can help me out. I have a subform based on the linking table for a many to many relationship. One table is based off of customers, the other table is based off of tags (think of tags you can use in Gmail to categorize contacts as friends, or coworkers, or whatever you want). The linking table associates a person with a particular tag (similar to the orders detail table does in Northwind). The drop down (this is a continuous form by the way) on the form currently shows all of the tags that exist. What I would like is for the user to select the first tag. When the go down to add another tag and use the drop down though, the 1st tag choice is no longer listed as an option (preventing them from adding the same tag to a customer twice). Any ideas?
I appreciate the help,
Troy
I appreciate the help,
Troy
