Multiple categories

[blander]

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??

 

[KenHigg]

I think you simply make this a one to many relationship - Or am I missing something...?

 

[neileg]

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.

 

[KenHigg]

Oh - I see....

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

 

[blander]

Cheers guys,

Really appreciate it!!