I have created a drop down list called 'Employee List' to auto populate to 2 different text fields, 'Employee Name/ID1' and 'Employee Status1', that part I've got.
When picking from the 'Employee List' and 'Regular' auto populates to the 'Employee Status1' the number '1' will auto populate to another text field named 'PayTypeStatus1'. If 'Temp' auto populates to 'Employee Status' the no '2' will auto populate to 'PayTypeStatus2' etc
The other step involves a separate drop down list called 'Acting Rate'. If an acting rate is picked it will need to override the Regular or Temp Status auto populated from 'Employee List' to say 'Acting', then 'Acting' will auto populate the number'11' to the 'PayTypeStatus' text field.
One more thing, if 'Auxiliary' auto populates to 'Employee Status' from the 'Employee List' the number 3 will auto populate to 'PayTypeStatus' BUT if an acting rate is chosen the status needs to stay '3', not '11' as described above.