Combining multiple Data Sources and then separating them to LookUp or search
Ok, so todays task. I am looking up Team Member certification. We can view the database by Team Member or by Process. We can then select the Team Member and see his Processes in the 2nd gallery OR we can select the process and see all of the Team Members that know it. Following? Hahaha
So, the next step is to take the details given in the 2nd gallery and search for the record in the database to view the completed certificate in a form. The problem: Everything in the galleries are a .Result as I used Distinct to get passed using 2 different databases.
My current theory is attempting to use Split in my search. Any thoughts? Maybe set a variable using split?