Question on Setting Up a Complex Find Formula
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.