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/93326.aspxFri, 27 Sep 2013 14:25:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93326gecabert0https://www.infopathdev.com:443/forums/thread/93326.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=93326Wow, I never thought something so simple, would be so difficult to figure out.... I'm trying to create a reasonably simple hardware asset database. The first issue I've run into is when I try and create a drop down list on a InfoPath form that looks up a field on another list that also happens to be a lookup field. Instead of pulling back text, it pulls back a number, which I believe is the ID? I think this also affects my lookup fields that try and use one of those fields as a filter. The field displays no data, because I don't think the number is being considered a match of the text. any advice would be greatly appreciated! I tried to keep the question as generic as possible to be of use to others. But I'd be happy to provide specific details and screenshots. George