I have two SharePoint Lists. One to many relationship. FireExtinguisherInfo (FEI) has an entry for each Fire Extinguisher. FireExtinguisherInspections (FEIN) has the multiple inspections for each extinguisher. I need a gallery to display FEI's that do NOT have an entry in FEIN's InspectionDate for the current month/year. The InspectionDate display's the date list this way mm/dd/yyyy.
This what I would like to happen:
Open screen and on that screen will be a dropdown with only the months available (if they want to search for previous months). The screen gallery will default to the current month/year and display the FEI's that do not have an entry in FEIN for this month/year.