1 Reply Latest reply on Mar 16, 2010 12:02 PM by philmodjunk

    Constraining  a find

    MonicaS.

      Title

      Constraining  a find

      Post

      Hi,

       

      I have a pretty simple request, but I need help with the script syntax.

       

      On my main form (called "Projects"), I have a field called Project Type that is populated with a drop-down list. Two of the choices on the drop-down list are "Residential Mixed Use" and "Non-Residential Mixed Use". The problem is this: when users go to do a search for Residential Mixed Use, they get all the Non-Residential Mixed Use records, too. There must be a way to control for this.

       

      I'm thinking that the answer lies in writing a script for the Project Type field that runs on OnObjectEnter in Find mode only. Is that right? And I'm thinking that the script should probably include an If line, and a Contrain Found Set line? or maybe an Omit Multiple Records line? Am I on the right track? A little syntax help would be greatly appreciated.

       

      I'm using FM10.

       

      Thanks, Monica