https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/24483.aspxThu, 15 Nov 2007 20:13:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:24483Clay Fox0https://www.infopathdev.com:443/forums/thread/24483.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=24483<p>Glad to hear you are making progress Ed.</p> <p>One thing would be to make sure you have all of the related fields as text fields.</p> <p>Also I would verify there are no hidden spaces or characters you can try using the normalize function too.</p> <p>Typically you have to keep playing with it.&nbsp; Try copying the account num value from the table to the field in InfoPath.</p>https://www.infopathdev.com:443/forums/thread/24481.aspxThu, 15 Nov 2007 19:16:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:24481Ed Rodman0https://www.infopathdev.com:443/forums/thread/24481.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=24481<p>I&#39;ve been working hard on getting lookups to work, and finally I have done so. I have them working from drop downs and straight text boxes. Our accounts can be full text names like ABRA and they can be 600. My lookups work when I enter the text as in the case of ABRA, but when I try 600, (the rule does not return anything). Can anyone shed some light here. Thanks to Clay for his help in getting me over the hump.</p>