Given that i have only been using FB < 1 year and am an amatuer programming,
this may be too basic to take seriously, but please bear with me and TIA:

There is a "master" table CLIENT, primary key CLIENTPK (a column, there are
many others too).

There is a "detail" table INSURANCE, with a foreign key, CLIENTFK (a column,
there are many others too). There are many insurance records per client.

I would like to insert a new record in INSURANCE with the CLIENTFK filled
with CLIENT.CLIENTPK. The user has already used a SELECT * FROM CLIENT
WHERE CLIENTPK = :clientpk. The problem is complicated further by: what if
the user is running multiple SESSIONS (i think this is the meaning of
session), with multiple SELECT queries as above, open in multiple windows.

So, how do i get CLIENT.CLIENTPK into the INSERT for INSURANCE.CLIENTFK,
especially when i have multiple SELECTS for clients?