i am trying to update a dabase in the field from a program.
now i have created a new table and wish to add a refernces to the new table
to a table that i have add a field to..

the following code has a "syntax error in the CONSTRAINT claues." Error
which is of no help at all..

ALTER TABLE Exam ADD
   CONSTRAINT FK_Exam_Grading FOREIGN KEY
   (
       GradingBand
   ) REFERENCES Grading (
       GradeID
   )  ON UPDATE  SET NULL ON DELETE SET NULL
GO

if i remove the "ON UPDATE  SET NULL ON DELETE SET NULL" it works, but put
in the wrong type of releationship in to the database.

as any one got any ideas?

"Yes i have looked at the ACCESS Help file for the Jet eng..." and a lot of
good that did..