Thank you.

Thank both of you for your help, this cleared a lot of confusion for me.

Thanks for the reply, I was not aware that I was supposed to insert anything into the field since it is a reference to a Primary key field that adds...

Thanks for the reply. This one should be better.

USE Database1;

CREATE TABLE Job_Titles_4

(Job_Title_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

EE0_1_Classification VARCHAR(25),

Job_Title VARCHAR(27),

Job_Description VARCHAR(30),

Exempt_NonExempt_Status VARCHAR(1));

USE Database1

INSERT INTO Job_Titles_4

(EE0_1_Classification,Job_Title,Job_Description,Exempt_NonExempt_Status)

VALUES('Officials & Managers','Director Finance& Accounting','...