Finding Orphans

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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?
Click to expand...

The Unmatched Query Wizard.

John W. Vinson[MVP]
 
Back
Top