Is it possible to define an auto-incremental coloumn which increments by 'group' ?
I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text. I intend to trigger updates, inserts and deletions from this table, and use SQL in the trigger pgm to INSERT a record in a new SQL-defined table 'VERSIONS'.
This new file shall be keyed by (HOWTONO + versionnumber).
Is it possible to define the 'versionnumber'-coloumn such that it is incrementet [strong]within[/strong] the group of a [strong]single[/strong] HOWTONO number?