> > The answer is DON'T increment these keys manually. Use the DB as it was
> > designed and use generators to create the keys. You'll never have a
> > conflict.
> > Grab the documents off www.ibphoenix.com and read all about generators.
>
> I will use generators, but I have one question about generators. I
> have a table with a combined key, the first part of the key is given,
> the second part is a number that needs to be autoincremented. I think
> it can be done with a trigger, but I am not clear how.
>
> Table:
> Key 1: Value 1
> Key 2: 1
> ---------------
> Key 1: Value 1
> Key 2: 2
> ---------------
> Key 1: Value 2
> Key 2: 1
> ---------------
> Key 1: Value 1
> Key 2: 3
>
> Etc.
>
> TiA,
>
> Alexander

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
Alan