Hello Everyone,
I'm attempting to reference another tables to see if a company is on 'Credit Hold', but the query is throwing the error 'Invalid formula: Subqueries are not allowed in this context. Only scalar expressions are allowed.' each time I try to apply it. I am trying to apply this on the 'Table Design' with a formula field where it wont work. HOWEVER, it works just fine on the view details page. Any ideas?
SELECT CreditHold FROM CompanyCreditHolds where CompanyName = target.[@field:CompanyName]
The field CompanyName from the table CompanyCreditHolds is unique, so I'm unsure why I am constantly getting this error.
