How to re-read a table more than once

[morphanos]

I have a table containing two fields: 1.) a part number, 2.) the assembly where that part is used, if any.

I want a user to enter one assembly number so the report can display all of the parts used on that level. After getting the first level (easy), how do I re-read the same table to get the second level?

Example:

Part Assy
B A (part B is used in assembly A)...
C A
D A
E B
F B

If a user enters "A", I'd like to show a list of all parts used all the way down:

B
C
D
E
F

and not just

B
C
D

Does anyone know how I can do this?

[Madhi]

Then simply select

Select part from table

without where clause
Otherwise give more details