I'm suppose to make a table called MOVSTARDIR, and am suppose to have mvnum, starnum, and dirnum as primary keys with referential integrity enforced but I keep getting Cannt find table or constraint
Code:
CREATE TABLE MOVSTARDIR
(
MVNUM SHORT NOT NULL,
STARNUM SHORT NOT NULL,
DIRNUM SHORT NOT NULL,
BESTM INT,
BESTF INT,
SUPM INT,
SUPF INT,
PRIMARY KEY (mvnum, starnum, dirnum),
FOREIGN