Gary, research script triggers. when the field is modified it can "trigger" a script to perform the find!
Hello, Gary. Welcome to the FileMaker community!
Yes, there is a way you can do what you're asking. FileMaker has a series of Script Triggers available (in the Microsoft world, I believe they're referred to as Event Triggers). In your case, I would implement what you want this way:
1) Set up a global field with your value list attached. (You may have already done this.)
2) Write a script that grabs the value in that field and performs a Find. Might look something like this:
Set Variable [ $cid ; Find Customer ]
Enter Find Mode
Set Field [ CID ; $cid ]
Set Error Capture [ On ]
Set Error Capture [ Off ]
If [ not Get ( FoundCount ) ]
Show Custom Dialog [ "Error" ; "No record for that ID could be found" ]
Show All Records
3) Set an OnModify trigger on that field (your global with the value list attached). Set the trigger to run the above script.
Should do what you want.
P.S. There is a plugin for QuickBooks Pro out there, yes. Not sure about how to implement; I've never used it myself. Someone else can probably chime in.
We've used a different technique that preceded the arrival of script triggers and the Global Search for FMP.
It comprises a Quick Search portal which we have set off to the side of our main Customer layout. Above the portal we have two fields called QS 1 and QS 2. Into these we type first few few letters of the Customer's first and last name. The Portal then displays all matching customers. A click in that portal row takes you to that Customer's record.
It is implemented via series of relationships to another instance of the Customers TO which we have labelled "Customers QS"
Fields Last High, Last Low, First High and First Low are defined as shown here:
and related as per the following diagram from the relationship set up dialog box:
The button on the portal row has this action:
I think you will find that this alternative to Script triggers works just as effectively.
Get back to me if you need any additional help.
Welcome to the FileMaker community! I've used Access in the past and I've never regretted moving to FMP full time.
Lots of ways to do what you're trying to accomplish. Another method is passing a ScriptParameter based on the CID you click on, then combined with a Script Trigger, anything is really possible. It really falls to what and how you want it to work.
As for QuickBooks integration, there is a plug-in from Productive Computing that works very well. The only downside is that Intuit (the makers of QB) only has an API for the Windows version, which means that your solution will have to have at least one Windows machine with the plugin installed to function.
Good luck, and again, welcome!