Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Populating Parent-Child-Grandchild
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?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement