1 2 Previous Next 15 Replies Latest reply on Jul 14, 2016 2:57 AM by roycash

    Omit record if portal is empty

    roycash

      New user , FM 14, still working through the trial.  I made a layout with a portal. The portal records are selected from a master data table filtered according to criteria in an input table.  I want to have a view omitting any records with an empty portal. I read over a few of the posts on omitting records but don't know how to access the record count in the portal. If no records are there, it l looks like there is no data to access.  I haven't started with scripting and still learning about functions. My filter has 9 pairs of conditions, any one being enough to select a record.  Can I use an IF function to add some flag record if no records are selected from the master data table?

       

      I am also curious how I could save all of it in a new table linked to the  input table.

       

      I am also having trouble with the filter selection but that may just be my syntax.

       

      From what i have read, this seems to be a great and valuable community for getting assistance and I thank you all in advance.

       

      Tom

        1 2 Previous Next