Hi Jimmy,
I'm trying to do something similar and I think I understand the rules you posted above.
But when I execute the rule to query using data connection. My data fields never show any data. The only way I can get the data to show is if I tick Automatically retrieve data when form is opened.
However the list is quite large ...