AnsweredAssumed Answered

Copy Field Contents from a Filtered Portal to a Main Table Layout

Question asked by JasonTiller on May 22, 2014
Latest reply on May 22, 2014 by JasonTiller

Title

Copy Field Contents from a Filtered Portal to a Main Table Layout

Post

     Hello,

      

     I am sure that this question has been asked and answered many times, but I cannot find an answer that works for my needs.  I am very new to FileMaker and databases in general, so I would greatly appreciate any help you could give.

      

     I must keep track of all the applicants, current students, and former students in a graduate program in my department at a university and I have set up several related tables to do this.  My main parent table is "Students" and the child table is "Applications."  I have created a filtered portal in a layout based on Students that looks into Applications so that a specific related record appears at the top.  A person can have many applications to my department, but I only want to use the information on the top row and apply it to the context of my parent "Students" table.  Specifically, I would like to copy the value of a certain field on that top row of the portal to a field in my parent Students table layout so that I can apply some conditional formatting to that field.  Is this possible?

      

     Thank you.

Outcomes