AnsweredAssumed Answered

List view with related table

Question asked by MilutinPetrovic on Nov 27, 2012
Latest reply on Dec 3, 2012 by philmodjunk


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?