I have an inventory table, where I keep track of the existences day by day; so when I modify the existence of a product, I have to modify the existence from the day it's been modified to the actual date.
I'm implementing bussines rules for editing tables trough triggers.
The problem is that VFP doesn't allow a recusive trigger, so I can't modify the table that I'm testing with a trigger, just because if the record pointer moves, the actual record get updated, before the trigger fisnished.
I tried to open the table in a second work area, and control the recursive calls with _triggerlevel, but it doesn't seems to get recursive, it just detect the error and never made a recursive call to the trigger.
How can I ensure that the modification get all the historic records, every time an existence update is made ?
What else can I use instead of triggers in order to implement built-in bussines rules.

TIA