Surname, Forename problems

[lee_morgan]

I have forgot the way of doing this.....in one table I have 2 fields: Surname and Forename. I then have another table where the names input show the full name i.e. if in the one table the user inputs Surname: Smith Forename: John I want the field in the other table to display: John Smith

Thanks in advance,

Lee

 

[Eckerslike]

If you was to use a query you can just put the below in an empty field.

Full Name: [First Name] & " " & [Surname]

And then append it to the other table.