Forum Discussion
JohnThomas
8 years agoQrew Cadet
Basically you will get all the fields in the Child table by adding look up fields on the relationship. So that look up fields can be used in reports too.
Example
Person Table:
Fields : First Name
Second Name
Program Services Table:
Fields : Value
Relationship: One Person to Many Program Services
So if you create a table report a in Person Table:
Columns:
First Name
Last Name
Program Services (Link)
if you create a table report a in Program Services Table:
Columns:
Person-First Name
Person-Last Name
Value
Example
Person Table:
Fields : First Name
Second Name
Program Services Table:
Fields : Value
Relationship: One Person to Many Program Services
So if you create a table report a in Person Table:
Columns:
First Name
Last Name
Program Services (Link)
if you create a table report a in Program Services Table:
Columns:
Person-First Name
Person-Last Name
Value