Subject Re: [IBO] More info
Author bemmel2003
Helen,

the masterkey is generated and the generatorlink is filled. It works
all right. After inserting a master I get the generated ID at once.

My masterquery is a "multi-table-query"
SELECT TABLEA.*, TABLEB.NAME
FROM TABLEA INNER JOIN TABLEB ON TABLEA.NAMEID = TABLEB.ID
ORDER BY TABLEA.NAMEID

Keyrelation := TABLEA

My detailquery is:
SELECT *
FROM TABLEDETAIL
WHERE REFID = :ID ORDER BY ID

Leon




--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 12:19 PM 10/06/2003 +0000, you wrote:
> >string-key
> >After detail-insert I immediately see the master-key in my
> >detaildataset
> >
> >integer-key (not null)
> >After detail-insert My masterkey-fields remains empty
>
> Is the master's primary key being filled by a generator? If so, do
you
> have the master's GeneratorLinks property set up?
>
> Helen