8 Replies Latest reply on Mar 23, 2010 12:45 PM by BMiller

    Relationships on forms

    BMiller

      Title

      Relationships on forms

      Post

      I'm still new to Filemaker and I'm trying to figure out a couple things.

      I have a project table and it has several related tables.  Each of the related tables may have other related tables too.

      Project->Team Member->Task.  Fairly simple.

      I know a portal will automatically show the related team member records but I want to have a layout limited to the team members of the currently selected project.

      Here's what I want to do: while on the team member layout, browse just the team members (on a form or list) for the project that was selected on a different layout.  I also want to be able to add team members and make sure they include the proper projectID.  These team members are not stored in their own table for lookup because they are never the same.

       

      Thanks,

      Bill