I am creating my first database and I’m stuck
Quick overview – it’s a contact database. I have created 3 tables -‘contact list’ (contact name, organisation and contact details), ‘category names’ (26 categories in which a contact can be sorted into) and ‘project names’ (a record of what projects a contact has been linked to). Also created table for categories and projects - idea being that upon selecting numerous categories they can then be saved as a project.
Relationships created between the organisation table and each of the categories and projects table via ID number. Primary key is linked to the ID number allocated on ‘contact list’ table.
I have created my main form in which incorporates all of the above plus a form with command buttons relating to queries I have created for each category.
Problem:
End user would like to be able to do the following:
Select multiple categories and then be able to save them as a project name. I was thinking combo boxes or maybe multi-select boxes.
How do I create a query in which allows me to be able to complete this function?
I have already created a form which has a command button attached to each category query individually.
I hope someone is able to help me as I know there’s away - I've been reading many query forums but thought I would place my own question.


Quick overview – it’s a contact database. I have created 3 tables -‘contact list’ (contact name, organisation and contact details), ‘category names’ (26 categories in which a contact can be sorted into) and ‘project names’ (a record of what projects a contact has been linked to). Also created table for categories and projects - idea being that upon selecting numerous categories they can then be saved as a project.
Relationships created between the organisation table and each of the categories and projects table via ID number. Primary key is linked to the ID number allocated on ‘contact list’ table.
I have created my main form in which incorporates all of the above plus a form with command buttons relating to queries I have created for each category.
Problem:
End user would like to be able to do the following:
Select multiple categories and then be able to save them as a project name. I was thinking combo boxes or maybe multi-select boxes.
How do I create a query in which allows me to be able to complete this function?
I have already created a form which has a command button attached to each category query individually.
I hope someone is able to help me as I know there’s away - I've been reading many query forums but thought I would place my own question.


