I had a huge table (several fields) that I realized because of input on this forum was not a good idea and probably explained a lot of the "Access not responding" errors I was getting. So I decided to break this one table into many which I was able to do. I then started setting up a relationship between the tables, using the ID inserted by Access (Auto Number) as the primary in my main table and as the common key to connect to the rest. All went well until I found that the ID in one table had been designated as "text" instead of "auto number".
Naturally, just trying to reset the field would have been too easy. Access told me I had to insert a new field in the table and set it as "auto number which I did. I then saved the field and, as promised, Access inserted the numbers into the table in the new field. However, while it did insert all 649 numbers for all 649 records, for some reason it started with number 3 and stuck numbers 1 and 2 at the bottom of the field. Obviously, that is not going to work if I want this table to relate to all of the others.
Anyone have a thought as to why this happened and how to fix this?
Thanks.