Adding Constraints with Cascade

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi Glenn,

Are you trying to set Integrity rules? If so, what kind
of errors are you getting. Could be that the foreign key
exists in your 'many' table, but doesn't appear in
the 'one' table - which violates the referential integrity
you're trying to set.

Regards,
Jen
 
I can run
"ALTER TABLE Table2 ADD CONSTRAINT C1 FOREIGN KEY (FieldID) REFERENCES
Table1"
and the relationship is created fine but...
"ALTER TABLE Table2 ADD CONSTRAINT C1 FOREIGN KEY (FieldID) REFERENCES
Table1 ON UPDATE CASCADE ON DELETE CASCADE"
Comes up with a "Error in Constraint" message when I try to run the
code
Click to expand...

I think I answered this in tablesdbdesign: try using ADO and jet 4 instead
of DAO and jet 3.6. The cascade commands are not implemented in jet 3.6.


HTH


Tim F
 
Back
Top