M
Michelle H.
Hi There. I have a form that has 4 feilds: Date, Hours, Supervisor, and EE
Name. The Supervisor and EE name fields are drop downs. I would like the
user to be able to select a supervisor name and the EE Name field drop down
populate with the employees that report to that supervisor. Once the
selection has been made I would like the next record to be blank and follow
the same process. I have been able to figure out how to make the EE Name
field populate based on the selection made in the Supervisor field but the
problem I am having is that instead of the EE Name field being blank and
using the drop down, it automatically brings up the name of the first EE.
Any ideas? I'm stumped. Thanks.
Name. The Supervisor and EE name fields are drop downs. I would like the
user to be able to select a supervisor name and the EE Name field drop down
populate with the employees that report to that supervisor. Once the
selection has been made I would like the next record to be blank and follow
the same process. I have been able to figure out how to make the EE Name
field populate based on the selection made in the Supervisor field but the
problem I am having is that instead of the EE Name field being blank and
using the drop down, it automatically brings up the name of the first EE.
Any ideas? I'm stumped. Thanks.