Died and gone to lookup hell

[betheball]

I have a column in a table that pulls data from a lookup table. I no longer need the column, but can't seem to delete it. When I try, I get this message:

You can't delete the field 'Status.'

It is part of one or more relationships.

If you want to delete this field, first delete its relationship in the Relationships window.

However, when I open the relationships window there are no relationships shown. I am using progressively foul language the more I try to fix this, so please help.

 

[betheball]

Found the answer by accident. I figured all relationships showed in the Relationships Window by default. Guess not. Once I right-clicked in the window and chose the "Show All" option, I was able to see the relationships I needed to delete. I am guessing that the ones created automatically by Access when one uses the Lookup Wizard do not show without choosing the "Select All" option.

 

[Pat Hartman]

Access doesn't create relatinships automatically. You may have deleted the tables involved from the relationship window which simply removes them from view. To remove a relationship, you need to click on the relationship line and delete that first. Then you can remove the tables from the relationship window.