I am using Firebird 1.0, Windows XP professional, C++ builder 6, and
IBO...at this point, all i am trying to do is use Interbase Workbench to
design the backend of this database. I would like to accomplish this task
with a stored procedure or trigger.


"Svein Erling Tysvaer" > I guess it would help if you told us what
components you are using?

> >
> >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?
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>