Hi Paul. That's exactly what was happening! I realized that the sysnum() function was moving the record pointer in the carrier table. It's working now. :o)
Tracy
>Hi Tracy:
>
>Just a WAG, but what could be happening is that when you call sys_num("CARIER") the record pointer in CARRIER is changing and placing you at EOF. Because you have row buffering set ON, VFP will automatically perform a TABLEUPATE when the record number moves. So when you return back from sys_num and you REPLACE ca_sysnum you are at EOF, but because of the row buffering the other 9 fields were already saved when the record pointer moved.
>
>HTH,
>
>--Paul
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"