I have a client that wants to mimic the way many accounting systems seem to use forms during master file maintenance (ACCPAC, Dynamics, etc.)

When a user calls up, say, the Category maintenance form, she should get a blank form.

If she enters an ID in the index field and that ID already exists, that record should fill the form. If the ID does not exist, the form should go into 'add' mode.

I've been trying to implement this without reverting back to the GATHER and SCATTER commands.

My form automatically does an APPEND BLANK on opening and, if the user calls up an existing record, I TABLEREVERT() to get rid of the blank record.

MULTILOCKS is ON and CURSORSETPROP("Buffering", 3).

It seems that TABLEREVERT() does not kill the blank record if not required - I assumed that APPEND BLANK would only write a new blank record to disk when I issue TABLEUPDATE().

Can anyone help me here? I'd rather not have to write extra code to handle GATHER and SCATTER commands.

David Turnedge
Sydney, Australia