I just thought to add this to my post. All the drop downs are able to add and/or delete names and info. Like if a person quits they get deleted from the list of names. Or if a new person is hired, they get added to the drop downs. So, the script cannot be hard coded. Does that make sense?
Why drop-downs? It seems to me only the first field should be a drop-down and the rest text fields.
If you want to add new people to the list then you can update the data file or script.
To learn how to do it see: https://acrobatusers.com/tutorials/change_another_field
If you're interested in a tool that allows you to easily set it up see this one I've developed: Custom-made Adobe Scripts: Acrobat -- Populate Fields From Dropdown
I've seen the tutorial you sent to me before. It doesn't work for me. Like I mentioned the drop downs I'm using ALL allow information to be entered, alphabetized and deletes whenever I choose so any script which gets hard coded is not what I'm looking for.
Each drop down stores different information, but has the same names of the people. Let's say Dropdown1 is like this, Tom, Bill, Harry, etc and stores SSNs of the people. Dropdown2 has the same names but stores their addresses. Dropdown3 has the same names but stores their pay rate. Dropdown4 has the same names but different info. And so on for the rest of the drop downs. Not the same info in all the drop downs. The names and info gets deleted if the person quits or gets fired. Then the new person's name and info gets entered into all the drop downs.
I just wanted a way to select a name from the first drop down and then all the other drop downs would show that person's name but show the info stored in that drop down. But, the info isn't hard coded into the script, it changes all the time.
The script I'm using now works fine, but it takes too long to go thru all the fields (there's approx 50) and make the name selections from the drop downs.