Kevin et al,
I have a form to enter information into two tables (Inventory and InventoryDetail) in a One to Many relationship. In my testing,I put two records in the InventoryDetail table. In my InventoryDetail.PreSaveHook, I call an event to fill fields in my InventoryDetail table. As I trace through the event code, all works correctly. When I get to the Databehavior Save method, I see that if the table is optimistically table buffered the following code is run:
SCAN
IF IsAdding(ALIAS())
This.SetPrimaryKeyFieldState(FLDSTATE_APPEND_EDITED)
ENDIF
ENDSCAN
GOTO TOP
When I get to the GOTO TOP, all the information entered by the event object is reverted. I'm sure this is not by design. What can I do to fix this?
TIA
Rex