AnsweredAssumed Answered

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

Question asked by BERGSTEN on Apr 27, 2011
Latest reply on Apr 27, 2011 by 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!

Outcomes