Multiple Names from Form (1 Viewer)

JoseO

Registered User
Joined
Jul 14, 2013
Messages
66
Hello -

I thought I would make a simple form to keep track of participants attending weekly meetings. I've run into a bit of dilemma:

In my "Meeting form" I need to be able to add the names of all the people who are attending the meeting but I quickly realized that in the "Meeting table" I have but a single field name "Attendees."

Since I do not know from week to week how many people will be in attendance, I cannot have a "set" amount of "Attendee" fields. So, how would I go about including all attendees into one meeting into the meeting table?

Any help is greatly appreciated! Thank you.
 

jleach

Registered User
Joined
Jan 4, 2012
Messages
308
Attendees should be a in child table, at the Many end of a 1 to Many relationship between your meetings table and the Attendees table.

Typically, one might also have a list of Employees or People or something in a different table, which would be the source for the Attendees.

Probably you should do some light reading on Normalization, as these are fundamental concepts and are very important. There's a lot of material online covering the topic.

hth
 

Gasman

Enthusiastic Amateur
Joined
Sep 21, 2011
Messages
5,017
I believe you would need
Meeting table
Attendee table
and a link table that links Attendees to Meetings

HTH
 

JoseO

Registered User
Joined
Jul 14, 2013
Messages
66
Thank you for the fast response Jack. I appreciate it. I'll certainly do as you have recommended.
 

Pat Hartman

Super Moderator
Staff member
Joined
Feb 19, 2002
Messages
28,546
Here's an old database I build for my Access User Group to track attendance. Don't mind the colors, our president wanted colorful forms so I complied. I have removed all the real data and just left dummy data so you can see how the application operates.
 

Attachments

JoseO

Registered User
Joined
Jul 14, 2013
Messages
66
I apologize for the delay in replying Pat. Thank you so much for sharing this! I really, really, appreciate it!
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom