1 To Many relationship on the same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Can you please give me advice on how to build a query on the same table twice.

In English, I have a table of students. Naturally some of those students
have other family members. I want to be able to display them on a form or a
report. The other element is that some kids have siblings in later grades and
some have earlier. I was thinking that I might be able to link the table to
itself somehow and them build a query, thus form/report from there.

Thanks,
Joe
 
When you create the query just add the table twice. Access will add a suffix
like TableName_1 to the second usage of TableName.

Or you might use a junction table between them in the relationship window.
People --
PeopleID - autonumber - primary key
LName
FName MI
Sex
DOB

Junction --
ReleationID - autonumber - primary key (Optional)
PeopleID - number integer - foreign key - High side of relation
HighRelate - text - Parent, Sister, Brother, Uncle, Aunt, Cousin
PeopleID - number integer - foreign key - Low side of relation
LowRelate - Daughter, Son, Sister, Brother, Nephew, Niece, Cousin

HighRelate & LowRelate is not necessary but nice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL query with Many-To-Many relationship??? 2
Query with 3 tables with 1 to many relationship 7
Multi Value Many-Many Relationship Query 3
Trying to update multiple fields in the same record (same table) 2
Form queries from multiple tables 4
Many to Many relationships 3
Delete all one side records with no many side records 4
Many to Many Relationship 7

Back
Top