AnsweredAssumed Answered

Question on Setting Up a Complex Find Formula

Question asked by bt22true on Jun 5, 2010
Latest reply on Jun 9, 2010 by philmodjunk

Title

Question on Setting Up a Complex Find Formula

Post

I am trying to set up a button script, but I am pretty new to Filemaker. Ideally, here is what I would like to do:

On pressing a button, I'd like to enter find mode in a single feed (lets call it Product_ID) where I could punch in a number to search my records for. If the search is successful, I'd like the script to end, but if I do not find a matching record, I'd like a new record to be automatically created with my search phrase being entered into the new records "Product_ID" field.

 

Is something like this possible? Ideally, I would like to have a search dialog box open up in the beginning where I would enter the search term. 

 

Any help much appreciated.

 

-Brett

Outcomes