two fields as primary key in a table using the table Analyzer wizard? 1

[sidalam]

I have created a new access table.
I have imported a simple text file into the database
and using Table Analyzer Wizard to create tables.

How do I make two fields as primary key in a table using the table Analyzer wizard?

 

[dhookom]

Why do you want to use a wizard for this? You can open the table in design view, select the two fields, and make them the primary key.

IMHO, I prefer to use an Autonumber as my primary key. If there are other fields that need to be unique, I create a unique index on them. This opinion is not shared by all developers but it has never been an issue in apps I have created.

Duane
Hook'D on Access
MS Access MVP