Código SQL [-] INSERT INTO TABLA1 (CAMPO1, CAMPO2, CAMPO3, ...) VALUES((SELECT MAX(ID) FROM TABLA2), (SELECT CAMPOX FROM TABLA3 WHERE ID = :PID1), (SELECT CAMPOY FROM TABLA4 WHERE ID = :PID2), ...)
INSERT INTO TABLA1 (CAMPO1, CAMPO2, CAMPO3, ...) VALUES((SELECT MAX(ID) FROM TABLA2), (SELECT CAMPOX FROM TABLA3 WHERE ID = :PID1), (SELECT CAMPOY FROM TABLA4 WHERE ID = :PID2), ...)