I have Two Text Boxes on my form. One accepts the users input for his IDNUMBER. Once the user provides that number I want the second text box to return his name based on the data stored in a SharePoint list. So basically it should use the content of the first number as the look up value in the share point list. I have created a secondary data connections and even specified a custom formula for the second text box. It seems that if the first text box was a list instead it can work if I filter by ID, otherwise it doesn't filter by the IDNUMBER and instead takes in the normal ID.