Need: to show a subgrid or related record view that displays the grandchildren of a record
Let's assume there 3 entities:
A
B
C
Relationships are as follows:
A:B ==> 1:N
B:C ==> 1:N
So C is grandchild of A but it does not have a direct relationship to A, only to B.
Now on the main form for A, I want to insert a subgrid on the main form for A (use related records in the nav) that will show all of the grandchildren in C.
Is there a simple way to do this?
thanks,
J
*This post is locked for comments
I have the same question (0)