I have 5 to 6 years before a table at a client site hits recnum 99,999,999

Its a Time Stamp table with approximately 18 rows per shipment. There have been 4,000,000 shipments since the system was installed 20 years ago.

Currently it is at recnum 75,727,737
It uses the Native Dataflex database.

Nah, just kidding, it uses MS SQL 2016 ;-)

What happens when it wants to save recnum 100,000,000?
I would not object to it starting at recnum one overwriting the existing stuff. 25 years of record retention should be just fine.

No rush, but its nice not to leave these things until it happens.