Relationships Created by Lookup Wizard in a Table

[Larry]

I have several tables where the Lookup Wizard was used to create a "field
type" (understanding of course that the Lookup Wizard doesn't actually
create a field type but that's where it's lodged in table design). When you
do that, you get a message that the table must be saved before relationships
can be created indicating that the Wizard is creating a relationship.

The problem is that, when I later want to delete a field created in this
way, I get an error message to the effect that the field cannot be deleted
because it is part of one or more relationships and that the relationships
must be deleted in the Relationships Window before the field can be deleted.
However, when you go to the Relationships window, no such relationship is
displayed. It's apparent that some relationship exists, but I can't find any
way to delete it. In fact, the only way that I've found to get rid of it is
to completely delete the table and recreate it.

Surely there's a better way to handle this situation. Any suggestions?

Larry

 

[Jeff Boyce]

Larry

When you're in the Relationships window, have you clicked on the "Show All"
button? This sometimes will reveal tables and relationships that Access
seems to have "forgotten" to display.

If this doesn't work, try creating a new, empty .mdb and importing each
table you wish to keep. DON'T import the relationships -- re-establish
those after import.

Good luck

Jeff Boyce
<Access MVP>

 

[Larry]

Thanks, Jeff. This isn't the first time the "Show All" feature of the Access
Relationships window has tripped me up. I've never figured out what a
"direct relationship" is and why Access declines to show certain
relationships until you click the "Show All" button. Thanks, again.

Larry