Beth
I did not describe as well as I should have:
My tables are..
demographics table; basic demographics- has coach ID
certifications table: coach ID, courses, Surname, First Name
Team table: coach surname, first name, Team number telephone and email,
Player table Players , their team number, demographic information
The Team Table is the base or parent table for which I have a SUMMARY layout
The fields from this table; coach surname, first name , team number
From the child Certification table I have the coach's certifications
in a portal
Team Table is my root table
Demographic linked to Team Table via Surname, First Name (very safe
in this case since all the data comes from one source and names ARE
consistent, Identical in all the tables; small enough group that no
names are duplicated)
Certifications linked to Team Table via Name , Address.
Certifications linked to Demographic via ID
Barbara Passman
