i need, via query(ms access queries), add cascade of update and delete to enforce referential integrity.
i did:
ALTER TABLE Table2 ADD CONSTRAINT Relation1 FOREIGN KEY ([a],)
REFERENCES Table1 ([c],[d]) ON_DELETE_CASCADE_ON_UPDATE_CASCADE ;
it really show link between tables 1:n
but not allowed cascade of update, or delete, like if i do it manually on the relationship window.
why??
i need to send in my query "relation1", i mean constraint name as parameter that i am supposed to retrieve with another query .
how can i do all that??
i did:
ALTER TABLE Table2 ADD CONSTRAINT Relation1 FOREIGN KEY ([a],)
REFERENCES Table1 ([c],[d]) ON_DELETE_CASCADE_ON_UPDATE_CASCADE ;
it really show link between tables 1:n
but not allowed cascade of update, or delete, like if i do it manually on the relationship window.
why??
i need to send in my query "relation1", i mean constraint name as parameter that i am supposed to retrieve with another query .
how can i do all that??