Create incremental Ztable key

[Former Member]

Hello everyone,

I need to create a Ztable with a key (ZID) that must be a number (like NUMC15, for example), incremented as elements are added to the table. How do i know whats the number to follow. Imagine i allready have 356 elements. So next ZID = 357.

I searched the forum and found something about number ranges. I created one. But how can i link this to my table key ?

Thank you in advance.

[Former Member]

I guess there is no direct link.

But you have to read the table each time before adding the records to find the latest key value. Than propose the next key value. How ?

In the table maintainace enter your own code and make the key field display only in insert mode.

Note: When you generate the table maintainace code each time it will ovwerwrite your code

[Former Member]

Solved it on my own. I'm not using ranges. Just searching for select (max) of that field, and then increment +1. Thank you all.