1 2 Previous Next 15 Replies Latest reply on Feb 26, 2009 10:25 AM by Orlando

    When peforming a find, how do you limit the number of answers?

    AAgraphics

      Title

      When peforming a find, how do you limit the number of answers?

      Post

      We are using Filemaker Pro Advanced Version 9.0v3

       

      We are using the instant web publishing feature so the public can search our database.  The database can be located at:

       

      http://www.aa-coc.com

       

      Click on the area that reads "click here to search Certificates of Conformity"

       

      Type "27" in the item number field and click on find.  There should be about 18 records that are displayed.  You will notice that records 7 - 11 have the same item number of "27MIB".  However, the "Date of Certificate" is different for each record.  Instead of showing these five records after a search is conducted, I only want to show the three instances of "27MIB" with the most recent "Date of Certificate".  How do I do this?  Whenever a search is conducted, if there are multiple records with the same item number, I only want to show the three with the most recent "Date of Certificate".  Any thoughts and ideas of how to do this?  Thank you for your time and help.  If you have any questions, please let me know.

        1 2 Previous Next