AnsweredAssumed Answered

Script for matching data in one layout to another

Question asked by m10muhammad on Jun 23, 2010
Latest reply on Jun 23, 2010 by m10muhammad

Title

Script for matching data in one layout to another

Post

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

Model: 3455-7

Budget: $35000

 

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.

 

Muhammad. 

Outcomes