Broke Relationships When Field Changed to Autonumber

[Opcode]

I created a database with 10 tables and 8 relationships. Then, I learned about the Autonumber field type and decided that I wanted that to be the primary key of one of my existing tables, for a field that was already linked to 2 other tables. I had to delete the relationships and the original field to make the change, and Access said it had to delete an index, too. Now, Access won't allow me to re-establish those relationships.

I found that I had to change the fields in the other tables to match the Autonumber type and name of the original field, but now I am getting an error message stating, "Invalid field definition 'CustomerID' in definition of index or relationship. What does that mean? The field types and names are all the same.

 

[bob fitz]

Perhaps the following link to an earlier post will be of help: http://www.access-programmers.co.uk/forums/showthread.php?t=241063

 

[Opcode]

Perhaps the following link to an earlier post will be of help:

Oh, that's a good start, but it raises more questions, too. Access told me that I had to set the fields in both tables to the same type; originally, one of them was a text field, and the other an autonumber field. So, I changed them both to autonumber. The thread you linked also mentioned setting the field size. So, I have a lot of variables that could be changed (number of data types * number of field size types * number of tables), which is inconvenient to figure out by brute force.

My post count isn't high enough, yet, for me to include links, even as a quote of your post.

 

[bob fitz]

Read post #2 in the link. Try that and post back if you still have problems.