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
You are so close. I like the syntax; wish it could be this easy.
Assuming you don't care if more than one record is returned from GetRecords(), then you will just want to check the Size() function has calculated a value greater than zero (at least one record was returned), then mark 'Yes', otherwise 'No'. I don't think you need to get a field value from the other table (Provider main table), since you're just interested in a record existing; I could have a misunderstanding here.
If(
Size(
GetRecords( { "fid of Prov_ID on 'Member_Assignments'".EX.[PROV_ID] }, [_DBID_ASC_PREFERRED_PROVIDERS] )
) > 0, "Yes",
"No"
)