relationships

[Guest]

I have a column that I want to get rid of but it wont let me. It is telling
me that I have to delete the relationship in the box. I tried. It wont let
me! How do I get it to let me delete the column?

 

[Jeff Boyce]

We aren't there. We don't know what you are working with, nor working on,
unless you tell us.

The error message you are reporting implies that the column you are trying
to delete has been used in a relationship with another table.

While you might be able to work around this, think twice before doing so.
If the tables are related by a field (column) you delete, you will have NO
way to tell how the records are related.

Consider posting back a bit more information about the tables/field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pat Hartman \(MVP\)]

Are you sure you are deleting the relationship line and not the table from
the relationships window. Deleting a table from the relationships window
does not delete any relationships, it just removes the table from the view.
If you press the all relationships button, and the relationship comes back,
that is what you must have done.