Need Help with Forms / Subforms for project

G

gowingit

I'm having problems with a project. I am supposed to create a database for a
college tour guiding group. For each day of the week, the form should be
able to show the people who give the tour and the alternates for the tour in
a subform. I have created a table with the names of the tour guides, the day
that each is supposed to give a tour (datatype: text), and the days which
they are signed up to be alternates. (datatype: yes/no checkbox). I set up
another table for just alternate days and it has each day of the week listed.


I need to know how to set up the relationships to relate the table of the
day of the week with table of the scheduled tour guides and a subform with
the alternates listed.

Thanks.
 
Top