Relating one User (tech list) to many fields in the same Form

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
------------------------------