Tracking a "batch number"
I'd like to think this is an easy one.
I have several records that get brought in at once and I'd like to assign them a "BATCH" number that is 1 higher than the previous batch.
Easy right? The issue is that not every record has been assigned a batch number. (Other people entering records or other issues).
So while it seems like it would make sense that a Summary field asking for the maximum of "Batch" would tell me the value I need to beat...
If I happened to be parked on a record without a batch number assigned (like after importing the newest batch, for instance), the summary returns no value.
I should mention that I've set up a duplicate table and a "not equal" to relationship and am reading the summary from there so that no matter what my found record set is I'm always looking at all the records in the table for this value.
What am I doing wrong?
I'd love to be able to import a bunch of records, ask the database what the highest batch number is and then give this new import that highest batch number plus 1. via scripting.
(or, put another way, just before importing a bunch of records I want to ask the database what the highest batch number is, then import these new records and assign them a higher number automatically by scripting.
Thank you in advance: The knowledge base here is phenomenal.