5 Replies Latest reply on Apr 28, 2012 2:58 PM by citruspips

    Filtering empty records out of a portal

    citruspips

      Hallo everyone

       

      Sorry if this is a really stupid question but its got me beaten.

       

      In table 1 I have field for "notes" into which data is occasionally entered. In table 2 I have a portal through which I can view the notes from table 1.

       

      Problem is it's showing every record, most of which are empty. I therefore wish to filter out the empty records but I'm doing something wrong.

       

      Could someone please help me select and build the necessary function.

       

      Many thanks in advance.