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

M

Melanie

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!
 
J

Jerry Whittle

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.
 
M

Melanie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Publisher 2019 Format Picture window size too large to display OK button 0
Finding the right style field in VBA 0
Size of RTF increasing 10x after minor edit 0
Template with fields and premade texts.. 0
Can't change data type 3
How to paste this down? 3
Delete all data after a symbol in a field 0

Top