Hi,
I have a TIB_Query with Select SQL like...
SELECT PURCHNO
~
, ITEMNO
FROM ITEM_PURCHASES_VIEW_PROC(?A_ITEMNO)
where A_ITEMNO comes from a Master query.

I want to have a Custom Insert SQL like...
INSERT INTO PURCHASES(
PURCHNO,
~
ITEMNO)
VALUES (
:PURCHNO,
~
:A_ITEMNO)
where, again, A_ITEMNO comes from the Master query, but I can't get this to work.

Is there a way to customise the insert SQL to include all the data entered into the connected TIB_Grid as well as the A_ITEMNO param?

Thanks,
Steve
(Legacy system still using V4.3.Ab & FB V1.5.6 if it matters.)