If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationships
I have to figure out a way to reperesent/enter camper activities. It seems
to be a many to many... I have many campers who will be singing up for many activities. How do I get that to come up on the sub form correctly... The main form is setup with the TbleCamperInfo as the primary table, with tabs and subs forms for the other corresponding tables... Let me know if it looks good so far... Here is a brief (not every field, but you'll get the idea) of the tables in question. Most all of the form stuff works well, until I get down to camper activities. You'll see below: Tblcamperinfo Camper ID autonumberPK camperfirst Camperlast Dob Age (etc) Tbleparentinfo Parent ID PK Camper ID Parentfirst Parentlst Parentst Parentcity Parenzip Parentemail (etc) Tblcmpercurrentyear CamperID PK Registrationdate Session Waitlist Cabin Counselor ID (from staff table) Counselor Name (from staff table) Agegroup (etc) Tblcamperactivities This one Is where I may need help We have a number of activities: canoeing, hiking, climbing, tennis (etc.) All offered 5 times a day (9:30, 1030, 11:30, 300, 500) I am trying to find the best way to set up the many to many relationship here… Do I create a table of activities, then a table of times, or just one table of each individual activity time? Then how does that work into a subform. How do I call that up??? Any help would be great… thanks a ton everyone!!! Don |
Thread Tools | |
Display Modes | |
|
|