I am taking an online Database Management Systems class and one of our assignment this week was to Write the SQL code that will create the table structure for a table named EMP_1. If you GOOGLE the question you will find a lot of people have already posted the answer
CREATE TABLE EMP_1(
EMP_NUM CHAR(3) PRIMARY KEY,
EMP_LNAME VARCHAR(15) NOT NULL,
EMP_FNAME VARCHAR(15) NOT NULL,
EMP_INITIAL CHAR(1),
EMP_HIREDATE DATE,
JOB_CODE CHAR(3),
FOREIGN KEY (JOB_CODE) REFERENCES JOB);
The issue I am having is this: every time I enter this into a Query I receive the error "cannot find table or constraint" My teacher says that this should work but she has no experience using MS Access 2013. The only way we have been able to get this to work so far is to remove the FOREIGN KEY (JOB_CODE) REFERENCES JOB); statement.
Can anyone think of any reason why this is not working?