April 27, 200124 yr Newbies I am very new at FileMaker I am trying to make a button that will perform a search if a field meets a certain criteria. For example: A field will either be: 10, 9.5, 9, 8.5... I would like a button that will search all the records listed as "10". or all records listed as "9.5"... Thanks for your help and patience.
April 27, 200124 yr I think I understand what you want. You want to enter a number into a field (10,9.5,9,8.5...) and push a button to find all the records with this value? If this is the case: Create a field: gField (global, number) Write the following script: Allow User Abort (off) Set Error Capture (on) If (IsEmpty (gField)) Exit Script End If Enter Find Mode () <----- Uncheck Restore and Pause Set Field (field, gField) Perform Find() <----- Uncheck Restore If (Status(CurrentError) = 401) Show Message (No records found!, OK) End If This search can also be done manually by just going to Find Mode, entering the value you wish into "field" and clicking the find button in the status bar. -bd
April 29, 200124 yr Author Newbies Thanks for the help but I'm still confused. Perhaps theres a more simple script? (im still new) Thanks for any help!
April 29, 200124 yr You need to look in the Community forum for book recommendations and do some reading up on FileMaker. As simple as you can get is: Enter Find Mode (pause) <----- Uncheck Restore *** user enters number into field and hits enter *** Perform Find() <----- Uncheck Restore As a minimum, I'd read through the FM manual. -bd
Create an account or sign in to comment