Help!
I have a form which has fields for SPtitle, SPissue and a checkbox (SPcurrentissue) among others
The titles can be duplicates although will all have different issue numbers e.g.
Title01 - Issue01
Title01 - Issue02
Title02 - Issue01
Title03 - Issue01
Title03 - Issue03
I manually check SPcurrentissue on each record and have created a query to filter the records showing only the current issues which then leads to a report
Is there a way to automate the checkbox to tick if the record = the current (max) issue of each SPtitle ?
Hope this makes sense