I know its possible to query a fields value with a filter on... but is it possible to query and filter that date then set a filed to that same number but +1 ?
So as an example...
I have a PrefixValue field which is set to be either A, B, C, or D
I have a AutoNumber field (which i want to start at a certain number, say 8000)
I have a ...