I have a database with four tables, one of which is not relevant to this conversation.
A is the parent.
B is the child.
C is the child of B and grandchild of A.
I need a protal on a layout of A populated with records from C.
B is basically a join table so the tables are related thusly:
- A has key aID related to key aID in B
- B has key cID realted to key cID in C
Is this possible? If so how? I have tried, but if it is possible I am apparently putting the wrong key or filed in my portal.