Pulling Records from Table to Populate Multiple Inputs
I have an Employee Table that holds the list of all clinical employees. I have a master form where data is entered, capturing various stages of tracking. This means employees touch the tracking record multiple times. I need a lookup field that lets them choose the employee they want and then I need an auto-filled, scripted field that shows the names of the employee chosen. These must be unique for each instance.
How do I do this. I am able to get it work work if there is only one employee referenced, but when I manipulate other parts of the form, it wants to populate with the same employee name consistently throughout. I have made a values list that is looking up the employee for a unique label, but I can't get the script to run to populate an auto-filled text box with first and last name. Here is the script run on that box:
You'll need to describe your "Master Form" layout in much more detail. One what table is that form based? What relationship(s) have you defined linking it to the Employee table?
No such calculation should be necessary for what you describe if the correct relationships are set up instead.