On 24 Feb 2006 at 11:56, Kjell Rilbe wrote:

>"Detail" contains up to about five record for each "Master".

I'd put these queries into SP and turn them inside out:

FOR SELECT DISTINCT Id FROM "Detail" D
WHERE D."Code" = :Code INTO :Id DO
UPDATE "Master" M
SET "Info" = :Caption
WHERE M."Id" = :Id
AND M."Info" IS NULL;

--
SY, Dimitry Sibiryakov.