AnsweredAssumed Answered

Merging variable number of records from related table into layout

Question asked by cthygesen on Jan 31, 2010
Latest reply on Jan 31, 2010 by Jade

Title

Merging variable number of records from related table into layout

Post

Running FMP 10 on MAC OSX 10.6.2.

 

I am building an application where a component is to construct a letter with relatively standardized but variable content. I have created two tables 1) Letter, containing fields capturing recipient, date, topic etc. and 2) Contents containing Letter ID as a foreign key and a Note (Text) field. The relationship is one-to-many.

 

I am creaiting a layout based on the Letter table and wish to use merge fields coming from Letter and available notes from the Contents table. Obviously the number of notes varies for each letter. How is this achievable? Or should I take another approach altogether?

 

 

Outcomes