>>Looks like VFP may think that country 115 is a number and is adding the first digit from the code to that number so that;
>>
>>m.country + m.code = 118 (115 + 3)
>>
>>Try this and see if it helps;
>>
>>seek(TRANSFORM(m.country) + TRANSFORM(m.code),"table","IDX")
>
>Wouldn't seek()ing on a number in a character tag raise a "datatype mismatch" error?
>
>BTW, a colleague of mine always read that as "datatype mishmash" :).
Me too (and many Bulgarians also), because we have a MishMash meal prepared with scrambled eggs and vegetables :-))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.