View Single Post
  #1  
Old February 20th, 2006, 09:28 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default create field from two fields

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