Simple Question

[Guest]

I have a simple question but since I'm newish to access it's puzzling me.

I need to create an event management database where I track who from table1
is going to what events on table2. I've been trying to create table2 so each
event is an entry and then one of the fields would be a list of multiple
members of table1 but cant figure out how to do this. Is it possible the way
I've described it, and if not what's the best way to do it?

Thanks in advance

 

[Jeff L]

Table1 would be for your individuals(ID, Lname, Fname, etc)
Table2 would be for your Events(EventID, EventName)
Table3 would serve as a link between the two (EventID, ID)

In Table3 your entries would look like
1 1
1 2
1 3
1 7
1 10

That's probably how I would do it.

Hope that helps!

 

[Guest]

Thank you for your post!

So I would need to create a new table for every event I held then? I guess
I'm just a little confused as to the structure of the relationships.

Thank you in advance...

 

[Jeff L]

No, Table2, your event table would look like this
1 Event 1 Name
2 Event 2 Name
3 Event 3 Name
And so on
Basically this will be a lookup table for all your events.

The Table3 is how you would assign your people to your events. So if
my ID in the people table (Table 1) is 3 and I went to three events,
the entries for me in Table 3 would be:
EventID = 1, ID = 1
EventID = 2, ID = 1
EventID = 3, ID = 1

Table 3 will hold all the attendees for all your events.

Get it now?