14 Replies Latest reply on Sep 7, 2016 7:25 PM by philmodjunk

    Get field contents from another table

    jackmac

      Hi,

       

      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?

       

      TIA

       

      Jackmac

       

      Using FM14 Pro