3 Replies Latest reply on Feb 9, 2015 2:18 AM by disabled_Rob_2

    Global relationship

      Title

      Global relationship

      Post

       both tables have a global field (calculation =1).

      This establishes relationship. And provides field.

      but my field does not show any data?

      what? is my field suppose to be in a portal?

      i thought i could simply put the related field into list view and view data from 2nd table?

      this is what happens to me when i have not been using Filemaker for several years -- forgetting the basics!

       

      thank you anybody

      rob

        • 1. Re: Global relationship
          schamblee

          Is your calculation non stored calculation?   Relationship are based on their indexing and non stored calculation do not have indexing.

          • 2. Re: Global relationship

             

            Let's start over:

            i simply want to bring a field and it's data over into another table.

            i am not really relating anything!  Just want to view the data there!

            So i set up a simple relationship:

            Both tables relate a global number field. i simply put the No 1 in both fields which established relation.

             my text field with data now shows up and i select and insert it into my layout. But no data!! Not as a edit box!!  i can create a value list from that text field i want and when i format the field to a popup menu THEN my data appears. but i want my data to appear just in a edit box field.

            Thank you

             

             

             

             

            • 3. Re: Global relationship

              i GOT THIS SIMPLICITY TO WORK AND NOW UPGRADING IT.

              Thanks,

              rob