AnsweredAssumed Answered

"Set Field" With Criteria

Question asked by bivalve on Mar 4, 2009
Latest reply on Mar 6, 2009 by bivalve

Title

"Set Field" With Criteria

Post

Hi - 

 

Here is what I have:

 

Table 1: "Employees", which includes the fields "Name" and "Salary".

 

Table 2: "Salary History", which includes the fields "Name", "Salary" and "Active".

 

(In Table 2, "Active" is a 0/1 binary field that indicates which record in "Salary" is the employee's present salary.)

 

*** 

And here what I would like:

 

I would like to set Table1:Salary equal to Table2:Salary, where Table2:Active = 1

 

The part that is giving me trouble is setting the "where" criteria; I'm new to Filemaker, and this step sems like it ought to be pretty simple, but I am having trouble figuring out how to do it. 

 

***

Many thanks for the assistance; it will be greatly appreciated! 

Outcomes