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/58779.aspxWed, 08 Sep 2010 04:39:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:58779Aruna Akella0https://www.infopathdev.com:443/forums/thread/58779.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=58779<p>You should be able query using any database field. Is it not working for you? - how does the rule look?</p>https://www.infopathdev.com:443/forums/thread/58754.aspxTue, 07 Sep 2010 13:34:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:58754Tuomo Ilonen20https://www.infopathdev.com:443/forums/thread/58754.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=58754<p>Hi,</p> <p>Let&#39;s say I have database table with fields Personnel number (primary key), Person name and Person birthdate</p> <p>I&#39;m using rules to get person name displayed on&nbsp;custom&nbsp;field. Why I cannot get any value when filtering with birthdate, only with Personnel number? Can I retrieve data only using primary key fields?</p>