have a shared-access queue of 'currently waiting' items. I used a !deleted() filter, then simply delete the record after the job is processed. It'll drop from the index, and the grid-view (upon refresh) It is acceptable to have even 500 records deleted and 2 waiting because only 20-50 records come in per day. At some point (in the mornings) someone is going to run the app when noone else does. When this happens the environment setup code can grab and pack the file, just for housecleaning's sake, then return the file to shared use.
Michael,
Why not recycle the deleted records instead? IN your routine that adds the file to the queue just do something like this;
SET DELETED OFF
LOCATE FOR DELETED()
IF FOUND
RECALL
SCATTER MEMVAR MEMO BLANK
GATHER MEMVAR MEMO
ELSE
APPEND BLANK
ENDIF
SET DELETED ON
...