New to Filemaker. I would like to create a medical report which uses the
names of medications stored in a table. Would like to allow the user to
choose medication names, and then have these medications placed in a
text box as concatenated text separated by commas. Example of a
sentence: 'current medications include insulin, aspirin, Lipitor'.

thank you

You may (FMP6) create 2 fields, one ''Report' (text) normal, and one
'Medic' (Text) repeating field with 10 repetitions - or else 10
different Medications fields 'Medic1', 'Medic2', ... -.
The 'Medic' field will be set as a Value List filled with all the
values of a separate file (table) with one record per medication.
Be sure you show all the ten repetitions of Medic in your layout.
Then have the 'Report' field be a calculation :

"current medication include " &
Case(IsEmpty(GetRepetition(Medic; 1)); ""; GetRepetition(Medic; 1)) &
Case(IsEmpty(GetRepetition(Medic; 21)); ""; ", " & GetRepetition(Medic;
1)) &
Case(IsEmpty(GetRepetition(Medic; 2)); ""; ", " & GetRepetition(Medic;
1)) &
etc.

Remi-Noel

"Steven Rudolph" <srudolph (AT) synapsemed (DOT) com> a écrit dans le message de
news: miU8f.7441$u43.3647 (AT) twister (DOT) nyc.rr.com...

Sorry, my calculation had errors.
This one should work :

"current medication include " &
Case(IsEmpty(GetRepetition(Medic; 1)); ""; GetRepetition(Medic; 1)) &
Case(IsEmpty(GetRepetition(Medic; 2)); ""; ", " & GetRepetition(Medic;
2)) &
Case(IsEmpty(GetRepetition(Medic; 3)); ""; ", " & GetRepetition(Medic;
3)) &
etc.
Case(IsEmpty(GetRepetition(Medic; 10)); ""; ", " & GetRepetition(Medic;
10))

Remi-Noel