https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/84682.aspxFri, 23 Nov 2012 20:16:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:84682Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/84682.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=84682<p>I&#39;m guessing this is a SharePoint list form?</p><p>For your lookup column, you have to set the field to the list item ID for the item that is being looked up - so, let&#39;s say this is your &quot;Employees&quot; list and you have a lookup column to another list called &quot;Departments&quot; - you will need to set the field for that column to a valid Department ID - does that make sense?</p>https://www.infopathdev.com:443/forums/thread/84660.aspxThu, 22 Nov 2012 20:04:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:84660ProgressiveYum0https://www.infopathdev.com:443/forums/thread/84660.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=84660I&#39;m trying to use an InfoPath form to create a new list item and one of the fields that I&#39;d like to have it populate is a Lookup field. The intent is to set a value for the Lookup field so that related columns/fields will auto-populate based on the Lookup value. (Ie. My lookup column is MemberID and I&#39;m trying to retrieve data from a list containing demographic data. It works/auto-populates when I add items via DataSheet view.) That said, when I try to submit the entry, I get a red-dotted box with error message indicating &quot;Only positive integers allowed&quot;.