Hi,
There are a lot of ways.
-You might SCAN throug the table and replace in the other
-You may connect the tables and replace at once, check SET RELATION and SET SKIP
-You might use SQL UPDATE (UPDATE ... FROM)
Agnes
>i have 2 dbfs
>
>1. taxmaster.dbf
>
>taxmaster.dbf have 2 fields
>
>Effdate d && effective date
>taxrate n(5,2) && tax rate
>
>records in taxmaster.dbf
>
>Effdate Taxrate
>01.04.2007 0.00
>15.06.2007 4.00
>01.07.2007 12.50
>
>
>
>
>
>schild.dbf have 6 fileds
>
>
>billdate d
>billno c(8)
>product c(50)
>quantity n(10,3)
>rate n(10,2)
>taxrate n(5,2)
>
>
>
>
>
>i want to update taxrate in schild.dbf from taxmaster.dbf as per effdate and billdate.
>
>warm regards,
>mk.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]