Need help with a query

J

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
 
J

John M. Vazquez

Thanks,

Have one question what if and this is going to happen I have a father with
multiple sons

Thanks,

yanen.
 
J

John M. Vazquez

Ok ifound out what happens. However when I run this query I am not getting
all the table. I lose more and more parts as I to the design view. Now I
query with 8 records and have only 5 parts show?

Can ne1 help me? Please.

Thanks,

John M. Vazquez
 
A

Allen Browne

John, I'm not sure what's happening with your query.

Did you use an outer join between tables, as mentioned in Steps 2 and 5 of:
http://allenbrowne.com/ser-06.html
If so, are the arrowheads pointing the right direction between the tables
(as in the screenshot)?

Or did you add criteria to the fields on the outer side of the join?

For more info about those 2 ideas, see:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

If that does not address your issue, post your SQL statement so we can see
more of what your query is doing.
 
Top