Create a new field where? Are the fields text or numeric?
Do you have a good reason for combining two values into a single value? This
isn't normally good practice.
Do you know how to create a make table query?
Do you know how to concatenate expressions together using syntax like:
[LastName] & ", " & [FirstName]

--
Duane Hookom
MS Access MVP
--

"mackdiva" wrote in message
...
I have a property table and a tenant table. I would like to create a new
field
{propertyID} + {TenantID}. One property might have several tenants or
none
at all. Also this field needs to be a primary key for new table