Jump to content


  • Posts

  • Joined

  • Last visited

BGrambo's Achievements

  1. 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.
  • Create New...