Hi Robin

Sounds like your project is partially corrupt.

1. Repair your database:
Tools | Database Utilities | Compact/Repair

2. Go to http://support.microsoft.com, click on Downloads, and download and
install:
Service Pack 8 for JET 4.

3. Create a new (blank) database:
File | New.

4. Immediately uncheck the boxes under:
Tools | Options | AutoCorrect.
This feature causes many corruptions:
http://allenbrowne.com/bug-03.html

5. Import all the objects from your existing database:
File | Get External | Import

This forces Access to recreate the database objects, using the latest
version of JET, and without tracking old changes to the field names. You
should now be able to open the Relationships window, click Show All, and
rearrange your tables as desired.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jettabug" wrote in message
...
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