You can't change the data type or field size of this field error.

[Guest]

Hello!

I deleted all the relationships in my database and somehow it still tells me
I have a relationship somewhere. I want to change a field from "number" to
lookup and it keeps giving me this message:

"You can't change the data type or field size of this field; it is part of a
relationship. If you want to change the data type of this field, first delete
its relationship in the relationships window."

I DID !!!!!!!!!
Please help!

 

[Guest]

In the Relationship Window make sure that the Show All Relationships icon is
selected. You could have some hiding.

You may also need to go to every query and break relationships between tables.

Actually my best advice is DON"T DO IT! Lookup fields are evil. It might
even be another lookup field causing your problems now.

 

[Guest]

I deleted all the relationships, all the queries, all the reports and all the
forms. And it still didn't work.
I had to delete the table in question and it told me I couldn't delete the
table without removing the relationship to other tables. YES or NO. I clicked
YES and re-built the table from scratch.