Help with my query problem - Access 2000

[Cees555]

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.

 

[saomot2000]

What function(s) do you intend your button(s) to perform?

 

[Cees555]

Combo boxes or maybe multi-select list boxes where a number of categories can be selected. A command box to run the query and from there a command button ?? to link the query to a project name.

sorry - it's not very clear - i'm open to any ideas etc - doesn't have to be that way if it won't work as I haven't done this type of thing before.

 

[Mile-O]

So, you have this as a table structure?

tblProjects
ProjectID
ProjectName
StartDate
EndDate

tblCategories
CategoryID
CategoryName

tblContacts
ContactID
Forename
Surname
CategoryID
etc.

tblProjectsToCategories
ProjectID
CategoryID

Join every primary/foreign key field together in the relationships window; enforce referential integrity; cascade delete.

Open a query and select these four tables. Take what you want.

 

[Cees555]

Thanks for the info. Think I've worked a way to make it work.

I've found out so much info from the forum