1 Reply Latest reply on Nov 2, 2009 8:56 AM by philmodjunk

    Relationship problem



      Relationship problem




      I'm on Filemaker Pro 10 Advanced on a Mac.


      I've got a Students table with a primary key ID and an Ensemble table with a primary key ID.  I have a join table called Ensemble Participant Data which there is a portal into via the Ensemble table layout.  


      The Student primary key ID = the Student ID in the Ensemble participant data, and the Ensemble primary key ID = the Ensemble key in the Ensemble participant data. 


      When you're on the Ensemble layout, you select the student ID in the Ensemble Participant Data portal (by selecting it from a value list based on the student ID from the Students table and the Full Name field from the Students Table, which is an Auto-Enter calculation field combining the Student first and last name, set to replace existing value, and it is indexed), and that should then come up with the name in the next field in that portal, which is the "Full name" field from the students table.


      However, at the moment, it doesn't automatically put the name in.  If I go to that student's record via the Student table, I can see there that the student HAS been put into that ensemble (via a portal to the Ensemble Participant Data there in the Student table), and when I go back to the Ensemble table, I now CAN see the student full name in that field.


      But each time I add a new student, the name doesn't appear until I've gone and visited that record in the Student table.


      Any ideas? 

        • 1. Re: Relationship problem

          It sounds like your screen isn't refreshing to update immediately after you select a student from the drop down. When you created the portal, did you add the Full Name field from your student table or is it a calculation field in Ensemble Participant that returns the full name from the Student table? I believe that you've used the first approach.


          Check your Table Occurrence names in your relationship graph (the name at the top of each box). Make sure that the correct TO name was used when you specified the Full Name field in the portal. (It should match the TO title used when you set up the relationship linking the Student data to the Join Table.)


          I'm not sure, but You might get a difference in behavior if you find you refered to a different TO that also refers to the Student table.