In FilePatientRoutine, 159 Patient Advance Directives. I have a script to look to database and return value so that the existing entry does not get overwritten since the PM does not send this info. We are multi-org shared environment, and the script seems to work except for when the patient exists in multiple orgs, then I get the error, Script Error: <10>
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. <10>
Line: 24 <10>Column: 0Script Error: (30).
Any advice on how to resolved.