Referential Integrity

  • Thread starter Thread starter Marlita
  • Start date Start date
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?
 
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?
Click to expand...

Hello Marlita,

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

Kind regards,
John
 
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.
 
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?
Click to expand...

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!
 
Back
Top