Search results

  1. G

    SQL Insert Variable?

    I am stuck. I have a parent-child-grandchild applet I am working on. The user wants to be able to duplicate items at the child level and have it create the grandchild records as well. The parent record is keyed on Quote_No and Quote_rev The Child Records would be keyed on QuoteID, Quote_rev...
  2. G

    Parent/Child Issues

    I have a parent form with a one to many relationship to a subform. The parent form has an unbound text box that is recalculated via the Control Source of the object (we'll call it TB1). The Subform has a Qty (QTY) value and I want to recalculate another subform field (SFF1) based on whether a...
  3. G

    Subform Calculations based on Parentform data

    Greetings, I have a form with a subform in a navigation menu. Something like: Navigation Form NavigationSubform ParentForm (header data and some unbound calculation fields) Subform (Multiple lines tied to query) I have some fields in the ParentForm (i.e PF1, PF2) that would...
  4. G

    Grouping Question

    I have a working report which groups by a status field. Let's say I have Status (AA, BB, CC, DD, EE). It is grouping and summarizing fine. I would like to be able to merge some groups. So I would like to be able to Group on (AA/CC, BB, DD/EE). What would be the best way to approach this...
Back
Top Bottom