I created an app. using Visual FoxExpress. The app. has a process where a user selects a Project from a combo in a paramaterized view. a LOOKUP_POST process saves the PK from the selected Project. Once the user saves the selected Project, code in an ONSAVENEW that takes place after the Project has been successfully saved uses the saved PK to set it as the parameter for getting all of the Project's Child Objectives and saving them. The Objectives are gotten by Requerying the Objectives view based on the PK. It's important to note that getting the PK during the lookup process is critical to identifying the Project's related Child Objectives.

Here's the problem. The REQUERY_PERFORM code has an "IF" that reads: "IF .SourceType NotEqueal(I was not able to use the lessthan/greaterthen sign) DB_SRCTABLE AND TXNLEVEL = 0". This coe determines whether the requery is executed. The .SourceType NotEqual(I was not able to use the lessthan/greaterthan sign) DB_SRCTABLE is satisfied but the TXNLEVEL = 0 apparently is not.

I'd assumed that using the ONSAVENEW took place after a transaction completed but apparently not. Does anyone have any ideas on how to get around this?