Query all values that are directly or indirectly tied to an entry

[prost]

Hello -



I'd like to write a query that does this:

- I have a document that lists program names in one column, and the next column shows programs that are called by that program. These programs can then call more programs. This could loop for a while. I'd like to be able to input a program name (example, Program X) and then see that it calls, for example, Program Y, which calls program Z, etc. Also, Program X could call multiple programs (example Y1, Y2, Y3), which in turn each call multiple programs.

See attached for an example data set. I want to be able to query one program name, and see every program that is then called. I don't need to see which program calls what: I just need to see that program X calls all these programs either directly or indirectly in one list. In my example, I would want see that if I query "AJ0124", the result would be:

AJ0125

AJ0126

AJ309

AJ310

AJ311

AJ401

AJ400

AJ401

Thank you!

[davegri]

Your attached file is an Excel spreadsheet. This forum deals with Microsoft Access issues. Have you developed an Access database with tables to hold the data you seek?