Hello all,
Sorry if this question has been asked before I couldn't find anything exactly the same.
I am having the following problem.
I have three tables:
Contacts_TBL
Interests_TBL
ConInt_TBL
ConInt is has three feilds:
ContactID
InterestID
RelationID (primary key)
I have set this up in order to allow a contact to have multiple different interests, and allow the type of interests to be edited later by a user.
The problem is when I make a form for Contacts, the only way I know for a user to add an interest to a contact is by using sub-forms. Which do not really fit into my scheme, nor are they particularly user friendly. Is there a way to use the multi-value combo box as a UI to preform the same task at hand?
I know I could have just had my two tables and had a lookup field relating contacts and Interests, and in the properties set it for multiple values. However, later on in the DB I have a VBA search function which hates lookup fields so I am trying to avoid those if at all possible.
Thanks for any help in the matter, I am using MS Access 2010
Sorry if this question has been asked before I couldn't find anything exactly the same.
I am having the following problem.
I have three tables:
Contacts_TBL
Interests_TBL
ConInt_TBL
ConInt is has three feilds:
ContactID
InterestID
RelationID (primary key)
I have set this up in order to allow a contact to have multiple different interests, and allow the type of interests to be edited later by a user.
The problem is when I make a form for Contacts, the only way I know for a user to add an interest to a contact is by using sub-forms. Which do not really fit into my scheme, nor are they particularly user friendly. Is there a way to use the multi-value combo box as a UI to preform the same task at hand?
I know I could have just had my two tables and had a lookup field relating contacts and Interests, and in the properties set it for multiple values. However, later on in the DB I have a VBA search function which hates lookup fields so I am trying to avoid those if at all possible.
Thanks for any help in the matter, I am using MS Access 2010
