Jonathan,
I guess it would help if you told us what components you are using?

Set

At 10:26 27.09.2002 -0400, you wrote:

>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?