Finding Orphans

[Sprinks]

I recently combined several mini-applications into a single menu-driven
multi-application database. It is split into a local front-end file that
links all tables in the back-end.

In copying the multiple apps, I forgot to recreate the needed Relationships.
On attempting to do so now, I was unable to enforce referential integrity,
which I think means I must have orphan detail records already.

Can anyone tell me how to quickly find them?

Thank you.

Sprinks

 

[John Vinson]

In copying the multiple apps, I forgot to recreate the needed Relationships.
On attempting to do so now, I was unable to enforce referential integrity,
which I think means I must have orphan detail records already.

The Relationships should be set up *in the backend* - that's the only
place they can be enforced. Be sure to "Show All" in the relationships
window, they might be there already.

Can anyone tell me how to quickly find them?

The Unmatched Query Wizard.

John W. Vinson[MVP]