Hello,

> I have the following situation: I have a table which contains data
> based on an auto incremented value. But instead of only 1 item for
> each increment a increment can have as many items as needed. Within an
> increment the first part of the key is the auto incremented number,
> the second part is also a number that needs to be auto incremented
> within the first key.
>
> So a part of the table could look like this:
>
> Part 1, Part 2
> 1 1
> 1 2
> 2 1
> 1 3
> 2 2
> 3 1
> 1 4
> 3 2
>
> What is the best way to solve this? I think I need a generator which
> gets the last number (part 2) there is for a given entry (part1) and
> increment that value.

You cannot use a generator like that. Generators generate numbers.
Period.

If you want some weird sequence, you need to maintain it yourself.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com