Referential Integrity

[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?

 

[Gina Whipp]

Marlita,

Ummm, did you mean a message that says you have dat on one side that does
not atch data on the other? Or did you try to change the relationships
while you had the forms open?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[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

 

[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.

 

[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!