Need help on a report

[John M. Vazquez]

Hi,

I am trying to build a genealogy from my parts database. Every part has a
unique id. These ids are linked to the next part that is used by that part.
What I need to do is to research a part and all the part that are link to it
and then I need the part s that are link to those parts linked to the first
part and so forth. So it would be like a genealogy tree grandfather, father,
son, and so forth till the last gen.

If anyone can help please do so.

Thanks,

Yanen

 

[Al Williams]

John,

Take a look at:

http://www.mvps.org/access/queries/qry0023.htm

and then look for Joe Celko's articles at

http://linuxfinances.info/info/rdbmsmisc.html

for ideas.

HTH

Al