11 Replies Latest reply on Dec 3, 2012 1:15 PM by philmodjunk

    List view with related table



      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.

           Any ideas?