> 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