Sergey,

The problem is, that in BldMstr table the RecNum is not sequential, e.g. I may have RecNum = 700, then 50 records in the DoNotProcess file. So, I would end up creating a new RecNum in the BldMstr, but it would correspond to the wrong Source ID.

It looks like my first add should pick up the max number in Source file, but all other adds should pick up the max number in BldMstr...

BTW, check up your e-mail. I need a picture for flip functionality. Something similar to revert button, but with different angle and two arrows. I was unable to draw it myself...

>

SELECT MAX(RecNum) INTO ARRAY laTemp
>lnNextRecNum = laTemp[1] + 1
>

If table is open shared issue FLOCK() before SELECT just in case and UNLOCK after.
>
>
>>Hi everybody,
>>
>>Here is my situation:
>>
>>I've created Electronic Data Entry piece of Data Entry application. We receive files from registries in some text formats. I created a conversion program for each registry, that creates "source" file. Then another program processes this Source file and creates a work file, called BldMstr. This file has ID field called RecNum.
>>
>>There are some records in the source file, which should not go to the BldMstr file (nominal sales, for example). However, these records should go to "DoNotProcess" file.
>>
>>I number records in Source file sequentually.
>>
>>So, here is a scenario:
>>

>>BldMstr
>>   RecNum - 1
>>   RecNum - 2
>>   RecNum - 5
>>DoNotProcess
>>   RecNum - 3
>>   RecNum - 4
>>
>>
>>Source File
>>   RecNum - 1
>>   ...
>>   RecNum - 5

>>*************************************************************
>>In the Electronic Data Entry I allow some manipulations with BldMstr file, which basically allow to add new records. My problem is, I don't know, how to ensure, that each time, I add a record to this BldMstr file, I add a new unique ID.
>>
>>The DE application is stand-alone (not multiuser), so I was not using additional table (NextID table) idea...
>>
>>============================================================
>>Can you advise something in my situation, please?