Colleagues, how can I generate an identification code automatically?

[Paul Arsenio Blanco Reyes]

It turns out that I have a company table, in turn, the company can be classified as a client, as a supplier or both together. How to assign a consecutive to the company according to its classification?

[Val K]

define_table('company')

define_table('client', Field('id', 'reference company'), primarykey=['id'])

define_table('supplier', Field('id', 'reference company'), primarykey=['id'])