AnsweredAssumed Answered

Get field contents from another table

Question asked by jackmac on Sep 7, 2016
Latest reply on Sep 7, 2016 by philmodjunk



I have two tables in a system (client, event). They both have a 'client_id' field which I use as a relationship.


I have a layout based on the 'client' table which has all client details. I have a portal on that layout which, when you look at an individual client record it shows if an event is logged against this client in that portal.


I want to have a conditionally formatted button that is say red for 'yes' and blue for 'no', when it looks at the related record in 'event' and returns 'yes' or 'no' if that field is empty.


Any ideas?






Using FM14 Pro