Auto populate Primary key based on user selection in 3 dependent combo boxes

Highlighted
Occasional Visitor

I have a table with 4 fields viz Employee ID (Primary key), FirstName, Surname and Date of Birth. The combination of Firstname, Surname and DOB is UNIQUE.

My objective is to find out the Employee ID. I have designed a form which has 3 DEPENDENT combo boxes for Firstname, Surname and DOB respectively. 

I expect that after updating the 3 combo boxes a textbox should autofill to reflect the Employee ID. How should I approach this.

 

Depicting the above situation in attached excel file for easy understanding.

0 Replies