Question I've Alwys had and now Need Answered

[grandwheatgrass]

Hi! I have a question that I want to know if anyone has solved.

I have one table that has information on patients and another table that contains information their medications. In the patient's table I want to list the related medications in a "med, med, med, ..." type list for an emergency sheet that we print off. I know how to display all of the meds in columns in a portal (that is how we enter the meds), but can I have them summarized in a comma list form? Maybe a summary field that summarizes the content (text) of all related fields?

If possible I would like to avoid needing a script that would go through each med in the med table and then copy the names into a text field in the patient table in list form for each resident.

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/198675/post/305743/#305743

[grandwheatgrass]

Perfect! SOVLED! You guys are wonderful!