This could seem wierd but that is what I need to do,
I need that everytime a record is inserted, updated or deleted in a sql table, a trigger would tell VFP what specific record was modified then vfp will delete a reference in a treeview in an active form which contains a monitor of the status of the records, they aren't in the same order or display as in the table off course.
I don't know if this make any sence to you, any other way to to this would be greatly apreciated and reviewed.
just to be more specific , this is the scenario
an active form showing the records of a particular table in sql server, they are shown at a treeview
there is an insert, delete, update at sql server
this fires a trigger to tell the form, whixh record had been updated
the form call a method with some particular id that sql gave it to delete, modify, or insert a new item at the treeview
.......
DO WHILE .T.
ME.Work()
ENDDO