In 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