>Hi Gregory,
>
>Thank you so much for your answer! I study your code and It should work. But I have other problems here.
>I don't use to access the table directly, either buffers, etc.
>
>In my forms, I just want to fire one line -> Update Table_B Where BlaBlaBla Set Total_B = 100 and I want to VFP do the rest...
>But I think it is not possible... It is not possible this way.
>
>Thank you, once again!
hi Rodolfo,
It's possible with a trigger (I use a lot of them)
You can change the triggers in the table properties
eg
xx = dbgetprop('Table_B', 'Table', 'UpdateTrigger')
xx = xx + iif(empty(xx), '', ' and ') + 'Table_B_trigger("U")'
delete trigger on ('Table_B') for Update
create trigger on ('Table_B') for update as &xx
Gregory