1 Reply Latest reply on May 24, 2012 7:20 AM by philmodjunk

    Record Searches

    Marty1

      Title

      Record Searches

      Post

       Hi,

      I am looking for some guidance how to set up several searches for property management. I have fields 'Date', 'Roof', & 'Garden' to name but a few. I have 2 different search criteria:

      1) I wish to find properites build at a certain date (say 1970), with flat roof and Garden,

      I beleive the way forward is by using Set Field syntax,

      Set Field [house::Date; globals::Date]

      Set Field [house::roof_type; globals::Roof]

      Set Field [house::Plot; globals::Plot]

      Perform find []

      Presumably the system returns only the properties that match all 3 criteria?

       

      I now wish to find any property built in 1970 AND any property with a garden AND any property with a flat roof.   So this set of results will list any that satify any one of the criteria. Please can you help me with the syntax ?

      Thanks, Regards

      Marty

        • 1. Re: Record Searches
          philmodjunk

          Enter Find Mode []

          Set Field [house::Date; globals::Date]

          New Record/Request

          Set Field [house::roof_type; globals::Roof]

          New Record/Request

          Set Field [house::Plot; globals::Plot]

          Set Error Capture [on]

          Perform find []