Hello All,
Im running MS Access 2003. I have a database with many tables the ones in question are Clients and Employees.
My question is in regards to a form that I am using to maintain the Client information. I have set up relationships between the Clients and Employees, eg Clients.WorkerName = Employees.EmployeeName etc.
What I need is this, I have the selection of the worker for a client as a drop down option that will provide a list of the names of a worker as a combo box from the employee table. I have a field right next to that in which we manually populate the employeeID in order for other dbase features to function correctly. I want to be able to auto-populate the employeeID once a worker name is selected. Is there anyway i can do this with my current dbase structure? I want to be able to make this part of the after update event for that field...is it possible? would you provide examples of code?
Any piece of help would be greatly appreciated!