Ok, so I am making a very simple Book Inventory DB. All I want to do is make a button that will sit besides the "Author" "Series" "Ratings" and "Genre" fields that, when clicked, will look at the current information in the appropriate field and pull up al records that match. I can't figure out how to set up the button to look at a specific field.

Thanks for your help.

Jbob

This solution by NightWing might solve your problem.

Its a free demo so take a look at it.

http://www.nightwing.com.au/FileMaker/demos8/demo808.html

HTH

If you have FM 7 or later, you can send script parameter to script "Find Data" with your field contents...

Example:

Field: |AuthorField| [button]

On button you append script "Find Data" with script parameter AuthorField.

Script:

EnterFindMode

Set Field [AuthorField; Get (ScriptParameter)]

PerformFind

Ok, I got most of it. I have the find script written, but I am not getting how you send the information to that script.

Right now I just have

Enter Find Mode []

Set Field [books::Author]

Perform Find[]

When you push the button, it just says that there are no valid Criteria for this request. So I didn't fully understand how to get the second part of the "Set Field" part of the script.

Thanks for your help!

That is done where you assign script on a button in the "button setup". There you choose perform script and where you choose script form the list, on the bottom is optional script parameter and as script parameter you pass the field you wish to search on.

And you have to change setfield script step and include Get ( ScriptParameter ) as I wrote in first post.

That worked beautifully!

Thanks so much!!!

Edited October 23, 200619 yr by Guest