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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."