thanks4that

Based on the attached script, how could I expand this search out to user being able to search multiple fields and then the final 'archive omit', would it just be a case of deciding how many find requests are done before the script does the final constrain found set? searchmultiple.fmp12

Thank you so much for that... T

How do you get the line [search::archived; "yes'] next to the Set field? Still wont work search.fmp12

Have created a quick file to show whats happening search.fmp12

Thanks for the reply Lee, Client will only enter the first field and has no clue about omitting records, since the omit is constant the script could do this after client has made their chose from the first field. At the moment I have: Go to layout Enter find mode [paused] 'this enables client to enter their search criteria' New record/request Enter find mode [restore] 'I have put the omit criteria here' Perform find [] All I get is the last bit of the search, the first part entered by client is ignored

Hi there, New to FM and would like some help with a search, its for company chairman who refuses to learn how to use the new request feature! I'd like him to be entered into the find mode where he can select the field he wants to search, when he presses enter I need the script to then also search another field, which if it has any values omits those records, finally showing the end results. Many thanks Tony