When peforming a find, how do you limit the number of answers?
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:
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.