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/125209.aspxFri, 23 Dec 2022 22:07:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125209Masoud0https://www.infopathdev.com:443/forums/thread/125209.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125209In my form I have a drop-down list that is connected to a SharePoint list like below Items: **Doc** **Rev** Doc-0001 00 Doc-0001 01 Doc-0001 02 Doc-0002 00 Doc-0002 01 Doc-0003 00 in drop down list I like to show just Max records (just max Rev of each Doc like below sample), I like to know how can i do that in InfoPath, in MS Access with using sub query I could do but here i do not know. **Doc** **Rev** Doc-0001 02 Doc-0002 01 Doc-0003 00 Regards Masoud