Key violation error

[trixma]

I was trying to insert(append) some data using SQL into a table using access.
The code I was using is:
INSERT INTO FLIGHT(FlightNo, Capacity, DeptCode, ArrCode, DeptTime, ArrTime, WkSchedule)
VALUES('1', 120, 'MEL', 'CBR', '1040', '1110', '12...67');

There error comes from 'MEL' and 'CBR'

I created the flight table using the following code:
CREATE TABLE FLIGHT
(FlightNo TEXT(10) PRIMARY KEY,
Capacity NUMBER,
DeptCode TEXT(3) REFERENCES CITY (CityCode),
ArrCode TEXT(3) REFERENCES CITY (CityCode),
DeptTime TEXT(4),
ArrTime TEXT(4),
WkSchedule TEXT(7),
FOREIGN KEY (DeptCode, ArrCode) REFERENCES PRICES (DeptCode, ArrCode),
FOREIGN KEY (DeptCode, ArrCode) REFERENCES DISTANCE (DeptCode, ArrCode));

Price code
CREATE TABLE PRICES
(DeptCode TEXT(3) REFERENCES CITY (CityCode),
ArrCode TEXT(3) REFERENCES CITY (CityCode),
Price CURRENCY,
PRIMARY KEY (DeptCode, ArrCode));

Distance code
CREATE TABLE DISTANCE
(DeptCode TEXT(3) REFERENCES CITY (CityCode),
ArrCode TEXT(3) REFERENCES CITY (CityCode),
Distance NUMBER,
PRIMARY KEY (DeptCode, ArrCode));


When i delete the Foreign key code, i am able to insert the data.

My question is, is their away for me to append to Flight by using the same code without having to delete the foreign key information.

The foreign key has to be included as it is part of the schema i was given.

[Phil Weber]

Do you have MEL/CBR records in your Prices and Distance tables? The Foreign Key constraint will cause Inserts to fail unless related rows exist in the foreign tables.

[trixma]

Thanks. That helped me alot. I didnt have the correct records in the right table thankyou again.