Creating a counter...

[OMamed]

I'd like my front desk staff to keep track of phone calls and inquiry at the desk. I thought I would just create a field that was a serial number, and then create a button that would 'set next serial value'. But this does not work. Each day is a new record, and in this record, this value would be updated by just clicking on the button for the number of calls etc. I suppose that on creating the next days record, I would need to reset the serial number value back to 1. Can someone point me to an article or thread here that might help me? I looked for 'counter' but...

Thanks!

[Philland]

Since you want each new record to start at zero, you wouldn't use "set next serial value"

The script for your button could be just;

SetField (counter, counter + 1)

Phil