Getting Started

 View Only
  • 1.  Relating one User (tech list) to many fields in the same Form

    Posted 13 days ago
    Hello,
    I have a inspection list that has 4-5 drop downs for the roles involved in the inspection.  I want to pull from one user list to populate these roles.  The user list is in another table.  I can set this up for one of the roles in the inspection but am struggling to duplicate this.

    What I want

    1.Tom                                 Role A: 1,2 or 3
    2.George                          Role B: 1,2 or 3   
    3.Sam                              Role C:1,2 or 3
    Thanks for your help
    Philip

    ------------------------------
    Phil Heron
    ------------------------------


  • 2.  RE: Relating one User (tech list) to many fields in the same Form

    Posted 9 days ago
    Phil,

    Here are two options.

    First one is to make three relationships between your Tech Table and Role Table


    You will always have three Tech and three Roles even if they are blank values.


    However I suggest that you do this instead



    Now you can assign as many or few technicians to an inspection as you want and when you want.  In the Assigned Techs table every record has its own Create Date so you know that Tom was assigned on the 29th of January but George was added two days later.

    ------------------------------
    Don Larson
    ------------------------------