3 Replies Latest reply on Jan 19, 2016 5:33 PM by mikebeargie

    Groupby export combining a field from many records into one

    jstevens

      In FMP 11 I have a table of clinical rotations filled with information about preceptors and students.  I have a script performing a find with multiple requests and then sorting by preceptor number which is a unique field, some preceptors are involved in multiple rotations. I can export the found set and use the group by preceptor number causing any preceptors with multiple rotations to be combined into just one line, giving me a list of all preceptors used over a certain period or involving a certain group of students or both.  What I would like is to combine all the student names for preceptors with multiple rotations into just one field and have that export with the rest.  I can easily export all found rotation in the set when not using the group by option but as a time saving measure I need the students names combined when I use group by.  I am kind of stumped by this.