I am trying to figure out how to insert this functionality. I would like the user to select a value from the drop down "Name Field" and have it populate the "ID" and "Job Position" field based on a table. I do not want the table to be visible. I know I can do this through actions, however I have 60+ Names and there must be a better way.
I would like to information to reside in the form (Background, not visible), not an external resource if at all possible. The information will never change.
Then I suggest that you create an array to hold the information in a scripting object. This means that the array will be created each time the form loads and the array will be available to you at all times. There is an example using an array like this in the samples. Under the Help/Samples there is a dynamic purchase order sample. The country and states/province dropdowns get populated this way.
Start there and if you need more help don't hesitate to ask.
How are the arrays created? Are they scripted in the initialized event?
Just reviewing the Purchase Order sample doesn't show you the details on what to do. It does confirm that it is what you want to do.
Any details you can provide will be very helpful.