Recursive Lookup and display?

[madyson]

Let's say I have created a contact database for my company, and that can include parents and kids working at the same company. Now I want to display (report or form - it doesn't matter) the contact info and include their parents if they exist. How would I go about it. Database sheet example below.

ID_Lname__Fname_MotherID_FatherID_Street
01_Schidt_Jack__02_______03_______124_Anywhere
02_Schidt_Awe___00______00_______125_Anywhere
03_Schidt_Oh____00______00_______125_Anywhere

If I want to print out the contact for 01 and then do a look up based on his parents IDs and include their names in the print out, how would I look it up? TIA.

[NTC]

your table is not normalized.

you need a field/column that ties them together...perhaps named "FamilyID" and then designate a value per family...

in this case maybe the Shmidt family is ID 35...so each of these 3 records would have all the value 35 in their FamilyID field...

then, if you want to identify whom is mother vs father vs son vs etc... you need a field named maybe "FamilyRole" for which you use a meaningful value - like M F S D

[madyson]

In the real one I have something similar, but what happens when you have several generations of grand parents, parents, and children. Such as a genealogy database. There has to be a way to look them up using the parents ID number, somehow.

[NTC]

well while I've never made a geneology db - one would presume they have 2 Family ID fields per record; one for the maternal family ID and one for the paternal family ID