Combining Fieilds Of A Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know how to combine multiple fields of a record in order to create
a unique and logical ID so that I can avoid duplications when importing
reports.
 
Kevin

Go to the design view of your table, and select Indexes from the View
menu. In the indexes window, type a name for the index you want to
create, set the Unique property (in the lower section) to Yes, and in
the Field Name column, enter the names of all the fields whose combined
values would uniquely identify each record in the table.
 
Back
Top