make table query

[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

 

[MacDermott]

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