Duplicate Values Between Two Tables
Hi Everyone, I will preface this with formulas are new to me. I have two tables Table 1 (Preferred Provider): This is the master table of only the preferred providers identified by Provider ID T...
Forum Discussion
Thank you! You have the intent perfect!
I can't use a key on the PROV_ID field on the Provider table because there are duplicates as they participate in different plans. So I tried your second formula and recieved a syntax error on the first quotation
If(Size( GetRecords( “{ 8 .EX.[CAP_TIN] }”, [_DBID_ASC_PREFERRED_PROVIDERS] ) ) > 0, "Yes,"No")
I rechecked your formula and moved the quotations to ({"8".EX. -this returned a syntax error on the first .
I think I'm just getting old. Ha! Help
Yes, I edited my response as I missed two double-quotes; in the query and around 'Yes'.
Using what you've supplied, try this:
If( Size( GetRecords( “{8.EX.[CAP_TIN] }", [_DBID_ASC_PREFERRED_PROVIDERS] ) ) > 0, "Yes", "No")