List Box Primary/secondary

Afternoon all,

ac2003

I have a problem concerning how to display records dependant or depending on the current record.

Basically I have a seperate area within the db that gives you the option to set which record(s) depends on or dependant to another record(s) as primary and secondary

When trying to display this info, it is fine for a direct primary - secondary within my listbox, but the complication occurs when the secondary record could also be a primary record of another record (if that makes sense).

for example. The data is as such,

PrimaryID SecondaryID
10 12
12 13
15 10


So from this data, my list box should show 1 record that this record depends on (15) , and in another list box 2 records than depend on this record (12,13)

I'm wondering if some kind of loop code would do the trick but not sure what angle to attack this at.

I would appreciate it if anyone knows a simple solution to this.

Thanks
Kempes.