AnsweredAssumed Answered

Filter/Search records based on 1 field

Question asked by JamesShallis on Aug 10, 2014
Latest reply on Aug 12, 2014 by yianyue


Filter/Search records based on 1 field


      I have searched for on the forum and found queries and responses that seemed to have been able to help those in a similar circumstances. I must apologise for my ignorance with Filemaker, I am very new to Filemaker and unfortunately have had this project thrust unto me by the powers that be, along with a deadline, so I haven't had the time to really get to grips with the functions or scripting. So if you are able to help, please can you dumb it down to the most basic level.

     I currently have 1 table with the following fields

     - ID

     - Meter Serial number

     - Meter Location 

     - Current Read

     - Previous Read

     - Advance


     The ID is the Primary Key, The meter serial no is a unique number to the meter, and the Meter location is one of 9 areas in a factory. I would like (if possible) to have the Meter Location field as a "search" or "filter", so the client selects one area, from a dropdown box or similar, then only the records that have meters in that "area" would be displayed. So the client selects "Area 6" and only the records from area 6 are displayed. If you could help I will be most grateful!


     Thanks again. ( as i said I am very new to this so please play nice).