> 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.

TiA,

Alexander