I think I did a poor job of explaining myself after taking a look at an earlier post. I gave it another shot.
I need some assistance with generating an automatic response based on a couple of conditions in other tables. In my survey table [VPRAITbl], which is the parent table to the [OutcomeTbl] (connected via the VPRAIID) an automated response is generated based on the client’s “Score” and their “ChargeCategory”. I have a lookup table [VPRAIResultsTbl] which contains all of the possible responses. I have an App Formula in the [VPRAITbl] “Recommendation” field that complete this: =ANY(SELECT(VPRAIResultsTbl[Results],AND(IN([Possibility],[_THISROW].[ChargeCategory]),[Score]=[_THISROW].[Score]))),
and it works just fine.
However, now I need to generate an automatic response in the [OutcomeTbl] based on the clients “Score” in the [VPRAITbl] and the “ChargeCategory” in the same table referencing the [VPRAIResultsTbl] where the response is located. When I write my formula (listed below), based on the above formula, I keep getting an error and can’t seem to figure it out. Basically, when the “Score” field in both the [VPRAITbl] & [VPRAIResultsTbl] match AND the “ChargeCategory” field in both the [VPRAITbl] & [VPRAIResultsTbl] match, I need the corresponding text from the field “ReleaseRecommendation” in the [VPRAIResultsTbl] to appear in the field “ReleaseRecommendation” in the [OutcomeTbl].
Here is my formula thus far which does not work:
I am guessing that I am missing something with the VPRAIID? Thank you in advance for your assistance.