how to use SQL INSERT INTO and maintain referential integrity

[freeskier]

Hello,
This should be a fairly simply SQL question. I have a list of scores which i want to associate with districts in my Access database. right now it is set up:

tbldistrict
distid name distcode rankid

tblranking
rankid ranking00 ranking90

where distid and rankid are PK and rankid is foreign key in tbldistrict.
I want to populate two tables from the list of information I have. The distcode is used to identify which scores from the list go to which district. Using

[code]
INSERT INTO ranking (dfg00, dfg90)
SELECT dfg.[2000DFG], dfg.[1990DFG]
FROM dfg, district
WHERE district.distcode = dfg.[District Code];
[\CODE]

will populate my ranking table but how do I match the foreign key value in tblDistrict? Hopefully I explained this well.

[PEB]

So a view tells that you can do this one:

INSERT INTO ranking (dfg00, dfg90, rankid)
SELECT dfg.[2000DFG], dfg.[1990DFG], distid
FROM dfg, district
WHERE district.distcode = dfg.[District Code];