Script for matching data in one layout to another
Version: FileMaker Pro 11
OS: Mac OS X 10.6.2
Background: My database is used for tracking printing machinery specifically relating to purchases, sales, inquiries, etc. There are three main tables: Contacts, Machinery, and Requests. The Contact table includes all of the people (customer, dealer) associated with the database. The Machinery table includes information on each machine either in stock at the company or available for purchase. The Request table has a form where customer's inquiries can be stored (i.e. they ask for specific make, model, and provide a budget).
Issue: What I want to do is create a script that, when run, will automatically see if the current record in the Request layout (i.e. a specific request made by a contact) matches with any of the machines in the Machinery table. So if the current record in the Request layout has the following info:
Make : Komori
I would want the script to see if I have any machines in the Machinery database with the same Make, Model, and a price that is either at or below the budget.
Please advise as to how I can accomplish this task.
Thanks in advance.