Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
6 months ago

Filter out some records on related table

I have two tables one called Provider records and one called descriptions.  The Provider is the child and the descriptions is the parent.  The descrition table has two fields named Record Type and Re...
Relationships
  • CarolMcconnell's avatar
    CarolMcconnell
    6 months ago

    I figured it out.  I orignally had it desplay the related description records directly on the form and had a report selected there.  I had to change that bak and then add the report for the When used for data entry. 

     

     

MikeTamoush's avatar
MikeTamoush
Qrew Commander
6 months ago

Filtering the embedded report should work. Is this on new form or legacy forms? Also, is it in the form or while doing a grid edit?

  • CarolMcconnell's avatar
    CarolMcconnell
    Qrew Captain
    6 months ago

    Legacy forms.  On the form, not on grid edit.  The field that should be filtered is Related Description.  This field has conditional values set.  I'm thinking it has something to do with this.

     

     

    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Captain
      6 months ago

      I figured it out.  I orignally had it desplay the related description records directly on the form and had a report selected there.  I had to change that bak and then add the report for the When used for data entry.