I have a infopath form for a registration list in SharePoint 2010. The form provides 3 different hotel options that participants can choose. These hotel fields are "Yes/No" type. Once a hotel receives 20 "yes" then I want that hotel option to be hidden on the InfoPath form. I know how to hide a field in InfoPath using rules.
I need help in creating a new rule, which will check the list for number of hotel options, and if any hotel has 20 "yes" or bookings, then InfoPath should hide that hotel field.
I am using SharePoint 2010 and InfoPath Designer 2010.