At 3:40 PM -0500 8/31/08, Steve Cassidy wrote
If you want one Mr Jones row in your export, giving demographic
information and then his courses in a, say, comma delimited form,
then you can use the List function to get all of the courses into a
single calculated field in the parent table. Export that along with
the demographic data, and you are done.
Yes, this is what I should like, ideally.
Steve's first suggestion , that of exporting each record from the
Child File would be the fall back.
I do not own FMP Developer so I cannot build a custom function ; that
is way beyond my skill.
Not sure how to use the LIST Function.
BTW-
I JUST Noticed something:
If I sort records in this view.
(sort alphabetically)
then do the export of fields but do not use the "group by" function,
I am getting something fairly serviceable
I can finally get an alphabetical list of my coaches showing all
their course certifications AND all the teams they are coaching. (
The export picks that up now from the duplicate listings in the Excel
file(Team ).
But I still would like to know how to use LIST or Calculation
that Beth described a few days ago.
Following the first responses from y'all, I built second database in
which i now have the coaches and their certifications in a Repeating
field.
I tried
8/26/08, Beverly Voth wrote:
newField_c = oldField[1] & "\r" & oldField[2] & "\r" & oldField[3] &
"\r" & oldField[4] & "\r" & oldField[5] & "\r" & oldField[6]
but must be doing something wrong as I still get only the first
repetition in the calculated field , I see my delimiting comma and
then a question mark. So I am not using this formula correctly.
Sorry for being so dense but I am learning as I go along
Thanks again
Barbara
