If I have two tables.
One shows First Name, and Last Name as two separate fields.
Second shows First Name and Last name in one field, with a space separating. The second table has information on it, that I want to relate back into the first table.
How can I combine these two?
How i did it was, I created a query which concatenates First Name and Last name, into a new control field called Full Name. I created a join relationship between Full Name, and the Second Table's primary key "Full Name".
I then created a second query, which brings in the Full Names, and then the related information in the table #2.
However - in this second query, i am unable to actually update say the First and Last Name at all - and have it autopopulate the table #2 updated data. It says I cannot update the recordset.