3 Replies Latest reply on May 11, 2010 1:45 PM by n/a

    basic portal question



      basic portal question


      Using FMP 8.5 with XP and am having difficulty with portals.


      I have three tables:


      • STUDENT INFORMATION (Fields = name, ss_number, student_id_pk, etc)....
      • ATTENDANCE (Fields =student_id, date_ID, ss_number, and attendance yes or no)
      • DATE OF CLASS (Fields = date_IDpk, date)

      The STUDENT INFORMATION table is related to the ATTENDANCE table via student_id.

      The ATTENDANCE table is related to the DATE OF CLASS table via date_id.


      I have created a portal on the DATE OF CLASS layout (based on DATE OF CLASS table) that references matching records in the ATTENDANCE table for student name, id, and ss_number. I have also created a drop down menu for student names from a value list based on the student names field.


      I use this portal for daily data entry of attendance and would like the student ss_number to prepopulate after I select/enter a student's name. Is this something that should happen automatically if I have the relationships correct, or will I need some kind of script for this?


      Any advice would be appreciated.  Thanks.

        • 1. Re: basic portal question

          It sounds like you are asking to pull information (via the portal) that is housed in a table that is not directly linked to your table.  ss_number is housed in the student information table which is linked only indirectly to the date of class table.  I think filemaker should be able to do this, however you may need a refresh script, or make sure everything is indexed......  But why don't you just link the tables to each other directly, via the student_id or via name.  That way entering in a name will display all appropriate fields via the portal from the student information database.



          • 2. Re: basic portal question

            When you populate the student ID in the Attendance table, you should then be able to put fields from the student table in your Attendance portal and display the correct information. You don't necessarily need to copy the SSN from student to attendance, you can display it directly from the related student.


            Your relationships as described sound OK. If you do want the SSN to copy over, set its auto-entry options to a calculation or lookup from students.

            • 3. Re: basic portal question

              Thank you guys so much. This fixed the problem.... I had to set the fields to auto-entry from the related records... worked like a charm.


              I owe ya one.:smileyhappy: