Make table with AutoNumber fields

[dsc2bjn]

I have a database which has the following tables.

AssessableUnit, Function, Activity, Risk

Each of the above tables has a AutoNumber field for setting the Primary Key.

I am trying to create a new table to store the values from related records
at any given time; however, the "make table" query bounces back each time
stating you can't create a table with multiple AutoNumber fields.

I tried setting the Properties to General Number, but that did not work.
Is there anyway to bring in the Primary Key values in a make table query
without inheriting the table properties?

 

[Maarkr]

I am trying to create a new table to store the values from related records
at any given time; however, the "make table" query bounces back each time
stating you can't create a table with multiple AutoNumber fields.

Why are you making a table to store the values? The values are already in
your tables, just use a query as the source of your form/report.

 

[dsc2bjn]

I want to store the given values for a particular time in history.

I wish to use the temporary make table to compare to the existing values to
compare the changes in data.

 

[Maarkr]

Well, if you must have all the autonumber fields, then you'll have to do make
tables for each table once, then use a append query to add the latest data to
them, and build a query to use for comparison...unless I'm not understanding
something.

 

[dsc2bjn]

Thanks! I came to that conculsion, but was trying to reduce the redundance
of the tables.

I can't see any other way.

Thanks again.