I'm using local views with local tables. My app. uses a "library" composed of a parent, child and grandchild (LibProjectIntro, LibObjectives and LibTasks) to "feed" the "Actual Work" ProjectIntros, Objectives and Tasks.

Users select the LibProjectIntro from a combo in a paramed view. A lookup_post saves the LibProjectIntro's PK. Once the user saves the selected LibProjectIntro, code in an ONSAVENEW uses the saved PK to setParam and Requery a CREATEOBJECT LibObjectives view. A loop then obtains each of the ProjectIntro's Objectives and another loop nested within the LibObjectives loop obtains each Objectives LibTasks.

Requerying the LibObjectives fails because TXNLEVEL is Not Equal to 0 in the Requery_Perform. I've tried placing the code in a Save_Post and after a DoDefault() in a Save_Perform. Both failed for the same reason.

The code appears correct. It's placement seems to be the problem. Where else should I consider placing it or is there a better way to populate the three tables after the user selects the ProjectIntro?