I don't have the time to show you in details, but you have done this completely wrong!
1. Open the two tables, Set relation properly, and Replace all for ..
To add the not found records:
1. Make a table of the not found by a simple SQL Select into a cursor
2. Append from this cursor to add the not found records
And by the way, with VFP9, you can do this with two lines of code, one to update, and one line to insert the missing records.
>hi,
>is this code make the same, if yes
>if not found how i can insert at typ (empty)
>
>CLOSE all
>INSERT INTO sss.typ;
>select *from tty WHERE tel in(select tel FROM sss);
>
>thanks.
>>>hi all,
>>>
>>>any help.
>>>i try to compare between 2 tables as under , but no result
>>>
>>>
>>USE tty in 0
>> m.tel=tel
>> m.typ=typ
>>
>>USE sss in 0
>>SELECT tty
>>scan
>> LOCATE FOR tel=m.tel
>> IF FOUND()
>> replace typ with m.typ
>> ELSE
>> replace typ WITH SPACE(10)
>>endif
>>endscan
>>