List view with related table
A quick question!
I have 2 tables 1 named "Employees" and another called "Family members", the are related via the ID field.
I would like to make a list view table in which under every employee his family members will be listed (if any). Is that even possible?
I used the Header-Body-Footer option and then added "Sub-summary when sorted by" under the Body section, but it shows only the first record for every employee.