Deleting a Relationship...REALLY deleting it

[Ogart]

Greetings:
I've got a table with a lot of junk data in it. (Some early poor design choices since recitified). I want to delete a bunch of fields and their associated data. I'm not allowed to do that because I've set up relationships between many of these fields and other fields in other tables.

When I go to the Tools/Relationship window, and I "delete" a relationship (by deleting the icon of the table that's connected to my main table), it merely disappears from view. If I "show all" that relationship comes back.

How do I REALLY delete a relationship? I'm going a bit batty with this one.

-->Just because you can, doesn't mean you should.

 

[jebry]

Hi!

Right click on the line between the tables and choose delete. Access is pretty sensitive about this action so be sure the pointer is really on the line.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[Ogart]

Star for you. Thanks for the help, Jeff.

-->Just because you can, doesn't mean you should.