9 Replies Latest reply on Apr 27, 2011 10:30 AM by BERGSTEN

    If related record is present, then Customer record is "Client"

    BERGSTEN

      Title

      If related record is present, then Customer record is "Client"

      Post

      I have two tables [Invoices] and [Companies] linked by Customer_ID. I'm trying to make the field Category in [Companies] read "Client" if there is a record in the Invoices table associated with that company. I've tried several different calculations and I can't seem to get it to change if there's a related record present.

      Any ideas?

      Thanks!