2 Replies Latest reply on Mar 31, 2010 5:24 PM by diamondage_1

    Data from related table not showing in field on report form

    diamondage_1

      Title

      Data from related table not showing in field on report form

      Post

      Hello,

       

      I'm new at FM, so this might be some silly mistake I'm doing.  FMP-Advanced 11 on mac Os X.

       

      I have a table [report] that my report form is based on that is linked to three other tables via a dual  key of   ID-Nr field and a Name field

       

      When I place a field from the related  tables in the body of the report, only one of the tables shows data.

       

      I checked the relationship settings and fields, everything seems the same between the three, yet 2 tables do not "produce" visible data in the filed on the sub-summary list view/report. Sort order does not seem to matter either.

       

      Any suggestions where the culprit may be?

       

      Thanks in advance, I'd appreciate any help...

       

      best

       

      oliver

       

       

      :smileyhappy:

        • 1. Re: Data from related table not showing in field on report form
          philmodjunk

          We'll need to see what your relationships look like. Here are two simple ways to show your relationships (use both):

           

          Table1----<table2   (---< shows 1 to many relationship)

           

          Show the match fields like this:

           

          Table1::Field = Table2::Field AND

          Table1::Field2 = Table2::Field2

           

          A quick check for differences would be to check the following:

          Check the field types of your fields to make sure they're the same for all sets of match fields in your relationships.

           

          In your name field, check for invisible characters such as a space character that may keep records from matching like you expect. (Name fields BTW, except for certain specialized uses, aren't a good field to use in a relationship.)

          • 2. Re: Data from related table not showing in field on report form
            diamondage_1

            Dear Phil,

             

            The Report table is the many table for all others. The relationship is as you wrote,

             

            Report::ID-fk = Table(2,3):: ID  , a Number field.

            AND

            Report::TableName= Table1(2,3 ):: Name,  a "text" data type required.

             

            Thanks to your field type note I found the mistake:

             

            The value for Table1(2,3): Name    

            is a calculated value, only the working table specified "Text" as the calculation result type, which is what was needed, the others were set to number !  Thank you very much for the pointer!

             

            It works now without problem.

             

            :smileyvery-happy:

             

            oliver