Relationship field error

[chrisalang]

Hello,
I am new to Access 2016 so please be gentle.


I am setting up various databases for my business. In one database for staff I currently have 2 tables. The first is their details and the second hours worked and overtime etc. I have set up a relationship between the two using the primary key in the details table and then a field called employeeid in the hours database. I have then set up a combo box with a drop down menu to enable me to drop down the list of employees and select them by name. This is all working but when i select the employee the error that this is not the correct data type pops up. Both data types are set to numerical and although I know the name is not numerical when I have looked at other databases with the same set up they appear to be identical to mine. Please can someone advise what setting I need to change. many thanks. Chris

[John_G]

Your combo box has to include the Employee_id in an invisible column (column width = 0, and usually the first one), and that should be the Bound Column. So, while you see the Employee name, you are storing the Employee ID in the table field you have set as the Control Source for the combo box.

[chrisalang]

Your combo box has to include the Employee_id in an invisible column (column width = 0, and usually the first one), and that should be the Bound Column. So, while you see the Employee name, you are storing the Employee ID in the table field you have set as the Control Source for the combo box.

Thank you - that has solved the error. I can now display the first name and surname in the drop down menu but when I select it only the first name is showing.

[John_G]

After selection, a combo box will show only the fist visible column (width > 0). If you want to see both first and last names after you make the selection, you will have to concatenate them into one field in the row source (query) for the combo box.