Reading Updating Inserting Indexed Table - Sequence of Events

[Mike Lambert]

Hi,
I have an indexed table. Index is customer number and date.

I have a transaction to update the master or create a new master file row .. but I don't know if the master file row exists.

Do I read the master file first to determine if the row exists and then take the appropriate action or try an update first. If this fails then I know to do an insert.

Pls don't give me a script ... I can't read them. Just the logical steps behind the approach.

Many Thks,

Mike