make table query

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi,

I was wondering in a "make table" query is it possible to assign composite
indexes that are unique?

If so how? How do I assign the primary index fields in it in the "Design
view"? I would like a certain field to be unique.

Thanks.

Peter
 
A make-table query does not create any indexes on the new table.
While it is possible to add these using ADD CONSTRAINT SQL, it's often more
efficient, instead of creating a new table programmatically, to simply keep
a table, empty it of contents, and use an append query to dump the new
records into it.

HTH
- Turtle
 
Back
Top