Gathering related data

[-bc-]

I'm not sure exactly where this SHOULD be posts but this seems as close as can find.

Here is my situation. I created a database with, among many others, I have a table for Clients and a related table for the medications they take (all related nicely). The medications table includes Brand name, generic name, strength, dose etc.

I also created a report following a predesignated format (need to stick with this format) and one box in the form requires a list of the medications only (generic or brand if there is no generic). I don't need any other data from the table for this report. So essentially I need a list formatted as so: drug1, drug2, drug3, drug4, etc. is there a way to do a kind of kind of do/while loop sort of

do

{

med_list = med_list & drug & ", ";

med_id++

}while client_id == specified client;

Or something like that? I could then use the med_list as a merged field in my report.

Thanks,

Bruce

[comment]

Try the List() function?

[-bc-]

Hi, Thank you, I totally misinterpreted the list function, that will give me the list. Can I then use the replace() function to replace the "/n" with a ", "? If so how do you represent the new line in Filemaker?

[comment]

Use:

Substitute ( List ( Related::Field ) ; ¶ ; ", " )

[-bc-]

Thank you

[-bc-]

thank you, that worked great