Referential Integrity

M

Marlita

I tried to enforce referential integrity after my forms have been populated
and my relationships established. I got an error message that I could not do
enforce ref. int. because things were already in use.

Is there anything that I could do to be able to enforce ref. int?
 
J

john.mctigue

I tried to enforce referential integrity after my forms have been populated
and my relationships established.  I got an error message that I could not do
enforce ref. int. because things were already in use.

Is there anything that I could do to be able to enforce ref. int?

Hello Marlita,

Try closing all open forms/reports before attempting to set the
relationship.

Kind regards,
John
 
A

Allen Browne

Use the Unmatched Query Wizard (first dialog when you create a new query) to
find the values in the table on the MANY side that don't match any record in
the table you want on the ONE side of the proposed relation.
 
J

John W. Vinson

I tried to enforce referential integrity after my forms have been populated
and my relationships established. I got an error message that I could not do
enforce ref. int. because things were already in use.

Is there anything that I could do to be able to enforce ref. int?

Referential integrity is applied to Tables, not to Forms.

If a form (bound to a table) is open then you cannot change the design of that
table; and referential integrity is a design feature of a table.

You really need to get your Tables correctly structured and related FIRST,
before you worry about forms!
 

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