>Hi Larry
>
>But you'd have to extract all the data from the parent on down right?
What we ended up doing for performance reasons was propagate the parent keys down the line into each table (after all, disk space is cheap). So the great granchild record has a field with the parent FK. We were then able to extract at any level we wanted.
When the form initallly loaded, we populated the all the views. Once the user wnet into Edit mode, we disabled anything that would cause a requery() (e.g. parent grid). However, all the child, etc. information was accessible using filtered views so they could navigate within a Parent.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao