How can I have an 'ID' field on my form auto-populate based on the month & year from another field (date field), and then an integer, incremented by one, from the last record, which contained the same month/yr.
So, if there are 3 records that were created in November, the 'ID' field would be 11-07-01, 11-07-02, 11-07-03? If a new record was created in Nov, it would be 11-07-04...
I have no problem getting the month & year to populate, but can't figure out how to have it look up existing records to see what the last integer was, and increment it by one...
Any suggestions?
Thanks!
Amber
So, if there are 3 records that were created in November, the 'ID' field would be 11-07-01, 11-07-02, 11-07-03? If a new record was created in Nov, it would be 11-07-04...
I have no problem getting the month & year to populate, but can't figure out how to have it look up existing records to see what the last integer was, and increment it by one...
Any suggestions?
Thanks!
Amber