Combining two fields question

  • Thread starter Thread starter JustMe
  • Start date Start date
J

JustMe

Not sure which group to place this question in.
Excuse my Duh...

I have a table whish has 2 text fields. I want to combine these
fields to make a unique ID field. Could someone explain please how I would
proceed with this?
Also, should I want to make this the key field?

Field1 = LName
Field2 = 4 digit number

Again both are text fields.

Thanks
 
I would advise keeping these as separate columns but
creating a Unique Index on the two columns combined.
Whenever you want to cimbine them in a report or on a form,
you can always create a textbox with a control source of
= [column1] & [column2]
where you would chage column1 and column2 to suit your app.

Hope This Helps
Gerald Stanley MCSD
 
In table design view, hold down shift key then click on
the fileds to highlight, now click on PK icon. Set the
index to unique with no duplicates.
This is known as a composite key.
Two days ago I had a similar post.
SteveAlb
 
Back
Top