AnsweredAssumed Answered

retrieving name from multiple fields in multiple records.

Question asked by RolandGomez on Jan 5, 2015
Latest reply on Jan 7, 2015 by RolandGomez

Title

retrieving name from multiple fields in multiple records.

Post

Filemaker World!,

Oye. I'm sure this is an easy one for y'all. I've been playing with filemaker for around 6 months and this is a hiccup I can't figure out. Here we go. We're a real estate company with 1) Multiple Employees who protest taxes for 2)Multiple properties. In some cases our multiple employees tag team to reduce taxes for a specific property. My goal is to retrieve all of the properties a single employees is associated with. Due to billing this is how I've had to set it up. Tax Consultant No. 1 and 2 are individual fields(which is located in our Properties table) that pull from a Value list that is connected to Employees table

Property A: Tax Consultant No. 1-Daniel;  Tax Consultant No. 2-Joshua

Property B: Tax Consultant No. 1-Daniel;  Tax Consultant No. 2-Casey

Property C: Tax Consultant No. 1-Roland; Tax Consultant No. 2-Daniel

Property D: Tax Consultant No. 1-Joshua; Tax Consultant No. 2-Daniel

In this instance I need to build a report that displays every property (record) Daniel is associated with. My thought was to create a separate field "tax consultant merge" and have a calculation that searches for those records where daniel is either TC No. 1 or TC No. 2. I can't seem to get it right. HELP!!!!!!!!!

Any information is greatly appreciated

-Roland (an aspiring filemaker guru...boy do I have a ways to go)

Outcomes