Ok.. I have a whole heap of records. defining field is tower - highrise or skyrise. From the main menu they select say "highrise" this then performs a script of

Perform find [tower=highrise]

Goto Layout

I need to be able to script a constrained search so that they can search on whatever field they like, but it will only return that search within tower=highrise.

I just created a button/script which only line was

Modify find

and this seems to work??? sounds all too simple to me??

That is the way it works actually.

have a look to this thread

But there is a new feature in FM 6.0 for "constraint find" if you're running it.

yeah I have FMP 6.0 and found the constrain set function but i had difficulty scripting it.

Sure I can do my initial search (Tower=Highrise) and then go into find mode and then select Requests/constrain set manually. I just couldn't work out how to script it so that it automatically pauses after tower=highrise and then awaits the user defined search, then sets that search to constrain.

Modify last find will work providing users cannot access the TOWER field and modify the search criterion it contains

Alternatively you might modify your script adding an hidden search criterion

Go to layout [search] (no TOWER field in it)

Enter Find mode (Pause)

-- User enters criteria --

Set field (Tower, "highrise")

Perform Find

This will add the criterion Tower="highrise" to any search ... it will work with any FM version

Thanks for sharing that tip !

Very useful. The most I read here, the less I need to buy FM6.

Thanks again.