Hi Keeda
Are you using Microsoft Access - if so what version?
If you are using Access then you are probably better of using lookup lists instead of writing the select query by hand. The reason for this is that access automatically writes the query for you by using the values you select whilst setting up the list.
Below is a step-by-step guide of how to create a lookup list:
Open table B in design view.
Select the Data Type column of the AwardPresenter field and click on the dropdown arrow.
Select Lookup List
Select ‘I want the lookup column to look up the values in a table or query’
Click OK
Select the table you want to look up (Table A)
Click OK
Select the fields you want to look up (Forename and Surname)
Click OK
Select any column you want data to be sorted by. You can leave this blank if you don’t require the data to be sorted.
Click OK
Adjust the width of the columns to whatever size you want
Click OK
Click Finish
A message box will then appear saying that you need to create a relationship. Click OK.
With the lookup list in place you will be able to select the name of the award presenter in the drop down list provided and the corresponding EmpID will be stored in the AwardPresenter field of table B.
For more information about drop down lists click here .
I hope this helps solve your problem. If you need any more help please let me know.
tmcpolin
