>Back again,
>> It was a typo, all of the l's look like 1's(one's). Changed all that I thought were<
>> one's to lower L. Program works, but still doesn't update all of the records.<
>> I checked both tables for ssnumber's and group codes. <
>> the source table client has all its ssnumbers and group codes <
>> I then opened the policy table in ssnumber order, then i looked at the <
>> fields ssnumber , and group code in a browse mode . It appears to update <
>> two times then quit, leaving two to three updates undone. <
>> My client table has 2085 records <
>> " " " " no group code records without numbers. <
>> " " " " " ssnumber " " " <
>> My Policy Table has 3091 records <
>> " " " " 37 records without ssnumbers <
>> " " " " 1125 records without group code numbers <
>> Any ideas ? <
>> thanks john <
John,
I can't believe this turned out to be this hard :) I suspect ssnumber is type char and field sizes are different causing match errors. Would you pls give table structures for those fields and tags you have with their key expressions.
Cetin