How fo I return the primary key value after INSERT using dbExpress?

[mercenguk]

Hi all.

I have an application written in Delphi 7 which accesses an Interbase 2007 database using dbExpress.

I have created a master / detail relationship between 2 tables using a nested dataset.

There is a 'Before Insert' trigger / generator on the master table which generates a unique id for newly inserted records.

This unique id is then used as a link to the detail table.

Is there an efficient way to return the newly generated unique value?

Many thanks in advance.

Regards,

MercEng