1:M/Multiple Reference Attributes

[Marianne Wyatt]

I have a multiple reference attribute. I have a case that is done in the hospital by a doctor. There is an attribute that allows them to put in multiple procedures done to a patient. I need this multiple procedure attribute to print out on a report. Right now when I reference it in the report it just pulls in one value in the attribute. How can I do that. I'm not sure I understand the way to do embedded reports and it seems that I need to do this that way. Is that correct?

[aware_support]

Yes, you are right you need to use an embedded report. The only trick when using such a report is to define the correct query for the embedded report so that it finds references of the parent object.

For example, if you have a Patient object and a Procedure object and a Patient has multiple references to a Procedure object in an attribute called Procedures the query may look like this:

FIND Procedure WHERE Procedure IN Patient.Procedures

Please also see the sample Library application where Member Details report has several embedded reports. Note the queries defined for these embedded reports

[Marianne Wyatt]

Thanks. I got the 1:M/Multiple Reference to work with a report. Is there any way to get it to work with a Word mail merge? There is no way that I can see to embed a report into a Word doc. Thanks.

[aware_support]

Yes, you can use embedded MS Word documents just like you use embedded reports. Please check out the SUB_DOCUMENT function in the manual. What you do is insert a tag with a SUB_DOCUMENT function:

<<SUB_DOCUMENT (...)>>

This function takes a query as a parameter - you can use queries similar to those used in the embedded reports to find multiple references of the object.

Please also check out LIST, LIST_TABLE and LIST_LINE functions that may be useful as well.