February 20, 201015 yr 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.
February 20, 201015 yr See if this helps: http://fmforums.com/forum/showtopic.php?tid/198675/post/305743/#305743
Create an account or sign in to comment