I to everybody!
I created a query like this in Access:
ALTER TABLE Ordini
ADD CONSTRAINT FKOrdiniIdCliente
FOREIGN KEY (IdCliente) REFERENCES tm_Cicli (ProductID)
It works rightly!
If I add two more commands
ALTER TABLE Ordini
ADD CONSTRAINT FKOrdiniIdCliente
FOREIGN KEY (IdCliente) REFERENCES tm_Cicli (ProductID)
ON UPDATE CASCADE
ON DELETE CASCADE
I receive a syntax error:
"Syntax error in CONSTRAINT"
Does anybody know why?
Thank you very much!