I have two combo boxes on my form.
The first box selects an Employee and is bound to the EmployeeID from the table: tblEmployee.
The second combo box selects the employee's pay rate and is bound to the PayID which is on a related table: tblPay.
(Employees can have a variety of different pay rates depending on the job they are performing.)
I need a SQL statement for the row source of the PayID combo box that will only display the PayRate(s) for the EmployeeID that is selected in the first Combo box.
My Current PayID combo box row source SQL statement returns all pay rates for all employees:
SELECT tblPay.PayID, tblPay.EmployeeID, tblPay.PayRate FROM tblPay;
I am hoping that it is as easy as adding a WHERE condition but I have tried several different approaches and haven't had any success.