2 Replies Latest reply on Sep 4, 2014 7:39 AM by hankt

    Matching fields to show activity entered in another set of fields.

    hankt

      OK this is complicated and I can't get my head around it.

      I would appreciate any suggestions on how to make this work.

       

      Field Name (in italic)

       

       

      SPORTS PROGRAM

      (Where Leaders are assigned to various Sports in each Period)

       

      Period 1 Period 2 Period 3

       

      Sport: Volleyball Soccer Basketball

      Leader1: John Amy John

      Leader2: Roger Rodger Steve

      Leader3: Sam Patty Patty

       

       

      LEADER ASSIGNMENTS

      (I want the Leader fields below to look up the contents of the fields above and show what each Leader is assigned to)

       

      LeaderName LNPeriod 1 LNPeriod 2 LNPeriod 3

       

      John Volleyball -- Basketball

      Amy -- Soccer --

      Rodger Volleyball Soccer --

      Steve -- -- Basketball

      Pam -- -- --

      Sam Volleyball -- --

      Patty -- Patty Patty

       

       

      How?

      What method can I use for the Leader Assignment Fields to find what each Leader has been assigned to in the Sports Program?

      Should the fields be in the same Table or in different Tables?

       

      I appreciate any help or suggestions on how to program this.

       

      Hank Tate

      hank@synogy.com