3 Replies Latest reply on Sep 7, 2015 12:49 AM by JamesThomas

    Problem with showing all related records.


      FMP 11 Advanced


      A database of say Countries, States, Cities. Data on each city is held in a related table. Relationship based on Cty.


      In "data entry" it works like a charm. However,  the print layout shows everything except the city data -  it shows data from the first related record only.


      The same problem occurs when exporting.


      Thanks in advance.  This is my first posting in this community - a decade ago I was active in "ironclad"??? and it was a delight.

        • 1. Re: Problem with showing all related records.



          Can you please explain the problem in detail and if possible provide the file.

          I would also like to know the relationship.


          Right now I can only say that try using subsummarry part with sorting on that table.

          • 2. Re: Problem with showing all related records.

            Hi James,


            There are  a couple of different ways to approach the problem you've outlined.


            The most common approach would be to build a print layout that is based on the 'child' (in this case Cities) table, so that each city record will be in the printed output, and of course you can include relevant fields from the Countries and States tables.


            Similarly, if you export from the Cities table and include some related fields from Countries and States, you will the data for all cities structured accordingly.


            There are other options for printing out related data - e.g. using portals and sliding techniques. They can be a little trickier to set up, so I suggest you try the above suggestion first and see if that works for your situation.




            • 3. Re: Problem with showing all related records.

              Many thanks Ray.


              The problem was that I'd built the printout from the wrong level in my structure. It's looking like success!

              Portals and sliding and many etceteras I already do.


              Thanks again,