Hi,
I have a table with a date and number fields.
The number field must start at 1 (default) and increment with each job-card created on that date.
For instance: Jan 1,2002 Job:1
Jan 1,2002 Job:2
.
.
.
Jan 1, 2002 Job:30
Jan 2, 2002 Job:1
One additional requirement is that...