I am trying to execute the following statement from in Access and I get the error: "Syntax error in CONSTRAINT clause"
Can anyone shed some light on what might be wrong? I have already created the LAYER table which is being referenced.
ALTER TABLE FEATURE ADD CONSTRAINT FEATURE_LAYER_FK FOREIGN KEY (layer_code) REFERENCES LAYER (layer_code) ON DELETE CASCADE
If I remove the "ON DELETE CASCADE", the statement works fine.