
I'm trying to create a report for data with several layers of relations.
Let's assume my data looks like this:
Mother
- Mother Name
- Phone Number
Child
- Mother (FK)
- Child Name
- Age
Toy
- Child (FK)
- Toy Name
Am I understanding this correctly that the "proper" AX way is to create Query that left joins all these rows and then in the report use grouping to recreate the nesting???
*This post is locked for comments
I have the same question (0)