Multiple categories

blander

Registered User.
Local time
Today, 16:37
Joined
Aug 8, 2006
Messages
14
Hi guys,

I am implementing a new database (Access 2000) for my company.

It contains contact details of a subscription base.

Four tables are present MEMBER, ORGANISATION, EVENTS and CATEGORY.

My problem is; people attend events, and i want to record this in the database. Each event has an event ID field, and an event description field.

When recording the events which people attend, i could just use the event ID field, but problem is that people can obviously attend more than one event..

Also;

People belong to a certain category

Again i have a category ID field, but people can belong to more than one category.

Any ideas on how to record this info??
 
I think you simply make this a one to many relationship - Or am I missing something...?
 
When recording the events which people attend, i could just use the event ID field, but problem is that people can obviously attend more than one event..
This is a many to many relationship. You will need a junction table that holds the memberID and the eventID. Do a search in these forums.
Again i have a category ID field, but people can belong to more than one category.
Another many to many.
 
Oh - I see....

Then I would suggest a 'Categories' table as the in-between piece...
 

Users who are viewing this thread

Back
Top Bottom