I'm not sure quite what you're trying to do but the following code should create the the records you want

INSERT INTO Table1(

RELATEDRECORDID,

FIELDID,

SOURCERECORDID)

SELECT

1,

614,

ID

FROM TABLE2 WHERE PROJECTID IN (18, 26, 20, 22, 35, 38, 148, 149, 155, 278)

I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961