I'm currently creating a swimming school database and would like some help in creating the relationships between the siblings in our swim school. On the pupil form I would like it to tell me if they have any siblings in the school and who they are. How do I go about setting up the relationship and can I use their PupilID from the same table. Any help would be greatly received!

---

Reply from Richard Rost:

I would make each pupil a record, and then join them with a junction table. It's a many-to-many relationship that I call a SELF-JOIN, and I cover this in my Access Relationship Seminar.