Relating one User (tech list) to many fields in the same Form
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 ca...
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 ------------------------------
