how to

[sdkramer]

I've got a list of people, and they participate in a list of activities. So I have a table for each of these activities.

Here is an example of what the data would look like for each of these tables

tblPeople: (PersonID, Name, Address, ...)
tblActivity: (ActivityID, Name, Date, ...)

Now my problem is I have nothing to relate them. So I create a table for participation and relate each of these.

tblParticipate: (PersonID, ActivityID)

Now I would like to build a form that will allow me to open a form to a certain activity on a certain date, and choose the people who participated in said activity. I've thought about this for hours, and tried many different things does anyone have any good solutions?

Is my logic incorrect for my tables, or am I just not creative enough in my solutions for forms?

Thanks in Advance,

Seth Kramer

 

[expublish]

I'm no expert but have you tried using a subform using the form wizard?

Scott

 

[David R]

Your logic is correct. Many participants can participate in any one activity, and many activities can be done by any one participant. Therefore you have a many-to-many relationship and need three tables as you've done.
This is my favorite topic for explaining how to create forms of this type: http://www.access-programmers.co.uk/ubb/Forum2/HTML/001389.html

Good luck,
David R