I am trying to reset an ID counter value back to zero after I run an Attribute Assistant routine. (line #3 below)
The EXPRESSION below runs standalone so the syntax works (I tested with a bogus value).
But run as a full routine it does not trigger the reset.
Do I have my triggering events messed up?
I set the Rule Weight so they run in order 1,2 then 3.
Is there a better way to reset the SEQCOUNTER to 0?
I have tried to run the 3rd step as a highest rule weight so that it triggers first but no go.@
Thanks for the help.
Text explanation of the 3 steps:
1. Select a line then run the MANUAL AA rules vie the toolbar.
2. The 1st method creates related records in a table called FiberStrand (this works great).
3. The 2nd method then numbers each record in the related table starting with 1. (this also works great)
4. The 3rd method is supposed to reset the counter to 0 but only works if I make a change to the actual GENERATEID table records.