Attempting to change data type for field but can't because....

[pixelpusher]

I'm a bit of a newbie, so lets just get that out of the way....

I have a field in a table that was originally a text data type. I want to change it to a "lookup" data type using the lookup wizard. However, Access doesn't allow me to do this and prompts me with "You can't change the data type....its part of one or more relationships...". But there are no relationships? There may have been previously, but I've deleted them all from Relationships window.

This has happened several times now. I am in the process of designing the database and have been changing my mind about data types when I realize that I can use a lookup data type. The only fix I have found is to make a copy of the table in question and then change the data type of the problem field. Unfortunately this screws up my forms...which is a pain.

Why would Access say that there are relationships in the relationships window when in fact there are none?

I've attach a copy of my db. The field in question is located in the "Activities" table. The field name is "ACTIVITY_NAME". I am trying to use a lookup from the activityNames table using the "ActivityName" column.

Thanks for any help in this matter.

 

[boblarson]

If at all possible, stay away from lookups in tables. Use forms instead. You can create your own lookups for the fields by using combo boxes or list boxes and you won't suffer later as lookups in tables can cause you grief later.

 

[pixelpusher]

I got the same warning about lookup fields on another forum. This solves my issue for now it would seem.

Thank you for the reply.