Why not create a compound index in pay table and use seek if you are just replacing on record.

Index Expression:
INDEX ON ins_co_nam+group_code TAG insgroup

and then

Select pay
=SEEK('A U L"+"A01","PAY","insgroup")
Replace here...


>No Jess,
>
>What I mean is, that instead of replacing "all" of the records with the (with) I only want to replace
>"one" record with the replacement value for the fields below . I was going to create an addational
>table and link it to paiddate, group code and insurance company name to handle this, but I feared
>an overall rewrite of the applacation and i'm trying to get around it.
>
>all of the fields are numbers (numaric) 8.2 and indexed
>chkamt (Check Amount) 8.2 number
>misc_amt (Misc Amount) 8.2 number
>gen_misc (Gen. Misc) 8.2 number
>
>John