0 Replies Latest reply on Jun 19, 2013 5:01 PM by vmiller

    Displaying field data from a related table

    vmiller

      Title

      Displaying field data from a related table

      Post

           Using the Projects starter solution included with FileMaker Pro 12, I am looking for a function that will find a Task record based on the field contents of [ Tasks::Task ] and display the field contents of [ Tasks::Date Due ] in a [ Projects ] layout. Task records for each Project are imported from an xls document that never changes. Xls Task examples: Creative Req, Proof, Approval, etc. On the Project List layout, I want to show the Date Due for a select few Tasks for each project along with the Status and Status Percentage that is already in the template. So, display in three separate fields: Creative Req Date Due... Proof Due Date... and Approval Due Date. Additionally, these due dates change periodically and need to update on the Project List layout automatically. Any suggestions for how to work this out?