5 Replies Latest reply on Apr 30, 2012 8:33 AM by MikeF

    Find field to filter records from a drop-down list

    MikeF

      Title

      Find field to filter records from a drop-down list

      Post

       

      I have a table Companies. 
      One of the fields is CompanyTypeID, which is related to CompanyTypeID in
      table CompanyTypes.

      Need to build a Find field on the Companies layout that will
      “filter” whatever CompanyTypeID I choose. Example -- in the Find field, when I
      drop-down to say, [CompanyTypeID 1] Media, it will find all Media company types
      in that layout.

      Will need this in a few more layouts as well, but am fairly
      certain if I can get this one working it can be duplicated elsewhere.

      Any assistance will be greatly appreciated.

      Thanks,

        Mike