Finding Orphans

S

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
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top