Hi Alexander, take a look at
http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries

I don't know whether "An Auditable Series of Numbers" helps you or
not,
Set

--- In firebird-support@yahoogroups.com, "a_broekhuis" <akhorahil@h...

> wrote:
> > store your fixed key values in a small table and use a select
> statement in
> > your trigger to get it and combine it into your key
>
> Getting the fixed key isn't a problem, the problem is that I don't
> know how to raise the second part of the key. It needs to increment
> that part depending on the fixed key.