Merging variable number of records from related table into layout
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?
Have you considered basing the layout on 2) Contents… instead of 1) Letter… and adding the related fields from Letter (Letter::recipient, etc.) in the Header part of the layout and Notes in the Body part?