Unable to change the field type in a table

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

Hi,

I'm trying to change the field type in a table from "text"
to "number", and I am getting the following error message:
"You can't change the data type or field size of this
field; it is part of one or more relationships. If you
want to change the data type, first delete its
relationships in the Relationship window."

This particular field is NOT connected to any other table
in the Relationship window, though this table has a
primary key and some foreign keys related to other tables.

I'm not sure what I'm doing wrong here, and how to solve
this problem.

Thanks for any help on resolving this.

-Amit
 
Remove the primary key first. This creates a hidden link to an index which
is causing the message. After changing the data type, reset the primary
key.

Kelvin
 
Back
Top