|Re: Locking tables or dirty read
> store your fixed key values in a small table and use a selectstatement in
> your trigger to get it and combine it into your keyGetting 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.