Hi,

I need a table to auto increment 2 fields, depending on each other. I
know i have to use a trigger and a generator, but my question is: How
can i increment the second field depending on the value in the first
field?

What I need is a table with 2 integers as prim key, the first is a
simple auto incrementing number, the second is auto incrementing
within the first.

EG:
1 1
1 2
1 3
2 1
2 2
2 3
3 1
3 2
...

TiA

Alexander