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
Table 2 (Member Assignments by Provider): This table is the universe of all member assignments-both preferred and non preferred. Providers are identified by Provider ID
What formula (and formula field) do I use in Table 2 that will look for a Provider ID match in Table 1 that will populate the new field in Table 2 as yes or no?
This app won't have user entries so I don't think I need a relationship. I just need to be able to match the preffered providers assigned in Table 2 to the master preferred provider list in Table 1.
I tried something super simple which, as you likely know, didn't work.
IF(Size(GetFieldValues(GetRecords("_DBID_ASC_PREFERRED_PROVIDERS.PROV_ID = _DBID_MEMBER_ASSIGNMENTS_BY_PROVIDER.PROV_ID")) 0,"Yes","No")
