Make table with AutoNumber fields

  • Thread starter Thread starter dsc2bjn
  • Start date Start date
D

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?
 
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.
Click to expand...

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.
 
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.
 
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.
 
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.
 
Back
Top