1 Reply Latest reply on Feb 24, 2010 1:17 PM by mrvodka

    Narrowing a search for records

    data_b

      Title

      Narrowing a search for records

      Post

      So I have this FMP database i have created, I would like to generate a report showing "Follow Up Dates" for my sales reps.

       

      I have created a layout with:

      header,

      sub-summary for the follow up date,

      sub-summary for the sales rep

      sub-summary for the hotel

      Body, showing contact, phone, and comments.

       

       It works, but it also shows ALL the other records.

       

      I would like to narrow it down to only the ones with follow up dates

       

      How would one narrow the search?

        • 1. Re: Narrowing a search for records
          mrvodka
            

          A subsummary report is based on the found set of records. Therefore if you perform the search and then report you will have what you need.

           

          Enter Find Mode [ ]

          Set Field [ FollowUp; "*" ]

          Perform Find []

           

           

          Go to Layout [ Report ]

          Sort Records 

          etc etc etc