AnsweredAssumed Answered

Can conditional formatting be used with 3 fields between 2 tables?

Question asked by MrsLLM on Apr 12, 2017
Latest reply on May 11, 2017 by philmodjunk

I have two tables, Employees (EEs) and Locations.  The tables are joined by District No.

 

Wanted result:  The calculated address and AKA fields to populate from the Locations table on the EEs table.

 

Every person works in a specific District.  Every district has a unique District No. and has numerous locations, some have nicknames, which I labeled "AKA".

 

Action:  Employees can only see and select an address based on their District No.  After an address is selected within the district, the calculated address and AKA fields populate under their name.

 

Not sure if conditional formatting, scripting or another avenue is better.  FYI:  Not an experienced script writer, yet - still learning Filemaker Pro Advanced 14.  Any help or suggestions are greatly appreciated.  Thank you!

Outcomes