How to populate textbox based on data in two comboboxes

[coreyalaurence39]

The issue that I am having is that I need to populate a text box with a pay rate based on data in two combo boxes. So the way it would work is that the user would choose the employee name in one combo box and than the Earning code in a second combo box. Than I need the pay rate to be placed in a text box based on the data selected in the two combo boxes. Each employee will have different payrates. So I need the system to look at the employees name and the Earning code and than provide the specific payrate for that employee based on the earning code selected. Is this possible to do?