lookup containing multiple fields

[Lisa_King_3]

hiya people

i have a field in tblEvents called member. This field looks up the fields "Forename" "Surname" "Gender" in tblmembers. however, when i selct one of the members in the database, it only insert the first lookup field, forename, into the member field. is there a way that anyone knows of that will enter both the forename and surname into the field member?

hope someone can help, cos I'm knew to Access

Lisa x

 

[bat17]

You can join fields using concatenation, so you can use
=[forename] & " " & [Surname]
To join your fields and display them

HTh

Peter

 

[Lisa_King_3]

hi, not to sound too ignorant, but where abouts do i enter that?

Lisa x

 

[bat17]

If the fileds are in the record scource for your form/report then you can just do it straight in a textbox.

If the field names are only in the Combo box then use something like this in a text box
=[cboName].[Column](1) & " " & [cboName].[Column](2)

where [cboName] is the name of your combo box and columns 1 and 2 are the columns with the names you want.
(Combobox columns start numbering from 0)

Hope this makes sense

Peter