Manually evaluate parent-child relationships

  • Thread starter Thread starter kev
  • Start date Start date
K

kev

Hi:

I would like to know how to manually evaluate the entire
hierarchy from a defined starting point, so that I can get
a list of records that depend on a master record. I
created a table where I define all relationships in the db
(four columns... parenttable, parentfield, childtable,
childfield, where the relationship is defined as
parentable.parentfield = childtable.childfield). The
starting point is on parenttable.parentfield = record id
in the parent table.

Linked tables may be part of the hierarchy.

I'm assuming that the code for this will be relatively
simple (like a Do...Loop nested in another Do...Loop), but
I haven't been able to work it out.

Any ideas?
 
Back
Top