I am using Access 2003 (200 file format) and trying to delete a primary key. I am told by the system that this field is part of one or more relationships... to delete the relationship in the relationships windows.

I go to the relationship layout window, choose "show all" and no relationships show up at all. Yet, when I choose each individual table, and tell it to "show direct", I get just direct connections for that table.

My first question is why doesn't the direct relationships show up when I choose "show all" and how can I make them appear so that I can delete the ones I can't see?

Thanks, Robin