autonumber and make table query

[Guest]

If I use "make table query" to go from a flat file DB to relational, is it OK
to use autonumber as the primary key in all the tables that I'll have to
relate back to the main table?

For example, main table now has one field in which one of four schools is
listed for each of the 3300 records.

Among the new tables, will be one with the four schools each listed one
time....but what then is the primary key for this new "schools" table that
will be used to relate it back to the "main" table? Autonumber is the only
way I can see to do this.

 

[John Welch]

It doesn't have to be an autonumber. It could just be a long integer that
you type in manually. But there's nothing wrong with it being an autonumber,
unless for some reason you have some sort of meaningful 'school ID number'.
-John

 

[tina]

yes, it's okay to use an Autonumber as the primary key of each table you
create, though i don't know how you plan to do this within the context of a
make-table query.

hth