I have a Customer Field and a Job# field as a key.
The form has a dropdown for the Customer which is populated with a Query, The query pulls the Customer and the Job#.
The form shows the Customer as 1 field (combo box) and the Job# as a separate input field (as text box).
What I need to do is to get the Job# from the Combo box selection auto moved into the form Job# field.
The form has a dropdown for the Customer which is populated with a Query, The query pulls the Customer and the Job#.
The form shows the Customer as 1 field (combo box) and the Job# as a separate input field (as text box).
What I need to do is to get the Job# from the Combo box selection auto moved into the form Job# field.