Hi,

I'd like to merge records into one field for reporting.

I have a join table where 1 patient is linked to several procedures. These procedures have a code. For reporting i'd like to merge these codes in one field.

I've attached a sample file.

Can somebody help me on how to do this.

I tried a list function but can't get it to work.

Thanks

vraag.fp7_.zip

Which code do you want? There's one in Procedures (a calculated one), and one in ProcedureCategories (with no data in it).

I`d like the one in the layout called "patientprocedures" to be merged in one field per patient on the report. So the calculated one.

Well, then point the List() function to that field (and that field only)

List ( Procedures::categorie code calc )

Make sure that the result of the calculation is Text. BTW, the same thing applies to the 'categorie code calc' field in Procedures.

Thanks this works.

Is there a way to display the result in a line meaning:

ABC

in stead of:

A

B

C

Got it: Substitute ( List ( Procedures::categorie code calc ) ; ¶ ; ", " )