Manually evaluate parent-child relationships

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse Parent/Child 3
Multi field link in table relationship 2
How do I display and enter data for a data hierarchy in access? 1
issues on table with relationship to self 2
Parent Child Tables and Relationships 6
Cascade Delete and N:N Join Tables 4
Deleting duplicate parents and grouping children to single parent 3
Relationships between tables and querys 1

Top