Hi, and thanks in advance for your help. I can't seem to get my brain around this relationship .
I have a file [Contacts]. Each Contact could have multiple Children for which I have set up a file [Children] and a relationship that works - no problem.
Now, a contact could be a Student. Also, a Child could be a Student. (Each record in these files has a "yes/no" field for Student.)
I need a third file for Students where a record will be created automatically from the Contact or Child file when the "Yes" box is checked for someone who is a Student. This file will also hold other information such as Emergency Contacts, Medical problems, etc. It will also be related to classes, events, etc.
I may just be stuck looking at this from one angle and not be able to see around the corner - hope you can help.