I'm using VFP 5 and am accessing BTRIEVE tables in an accounting system via Pervasive's ODBC driver. I have setup a connection and a remote view to look at the data. That was easy. Now I'm ready for something more advanced. Can VFP via RI or triggers or something of this nature, fire code when inserts, deletes or updates occur in the BTRIEVE table?

My situation is this. I plan to have the users have my app open when they go into the acctg system and have the connection online. I am hoping VFP, using the connection, can "detect" the inserts, deletes, updates and fire some code. My app will be sitting there in 'detect' mode.

If this sounds wierd, what I'm actually doing is enhancing a sales order entry system from the Platinum acctg pkg to be able to manage the data associated with size-sensitive case packs for a footwear manufacturing plant.

My application handles the solid size and musical/assorted packs in VFP tables and keeps this data related to the OE line records in Platinum. Additionally, though, I'd like the VFP app to be able to detect changes to the OE Line records in Platinum's BTRIEVE table and then fire code to maintain the VFP table when such events occur.

I have looked at TRIGGERS using 'create trigger...' and it doesn't seem to be able to operate on a btrieve table that I have a remote view setup for in my database.

Perhaps if I set access to the table using another method? Or perhaps triggers aren't the way to go?

Any help would be appreciated. Thanks in advance.

Stew