I got it figured, I added a rule to query data connection before the the rule that sets the field with a condition that ID of this value matches the lookup field value. Now the form opens fast and queries for the data when users selects an item in the look up field. However I have a new issue, one of the field that populates gives me an error ...