Great Day, I have a repair order form for a vehicle repair shop. I have a
combo box to display the technician who repaired the vehicle. The control
source is EmployeeID, which is the many field in the repair order table
(tblJob) that is related to EmployeeID in the employee table
(tblMasterEmployee). I have added another combo box to be able to display
the employees to choose which one is the service advisor, but I cannot
figure out a way to display two different employees on the same form coming
from the same table. Obviously, if I select "Joe Blow" as the technician, he
also shows up in the service advisor combo box, since I have used EmployeeID
as the control source for both.
Any suggestions will be greatly appreciated.
r/David
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar