I am a physician and i am indexing the cases in my emr manually to 06-MM-###

so the last tripple digits will be starting from 0 every month. so the 5th patient in may of 2006 would be 06-05-005 and so forth. is there a script that i can use to automate the entry with that fashion so when the month revolves it will reset the last 3 digits to 000 and the month to 06.

thx for any help i can get

Hi, sharadi!

See here http://fmforums.com/forum/showtopic.php?tid/175103/post/198608/hl/+aaa/#198608

There are attachment wich may be help you.

Thanx a million you guys are great

can you help me with how automate the date entry, in the thread you referred me to, it seems that i need to enter the date to generate the invoice number in the zip example, i still need to enter the date, is it possible to script that to be generated when i hit new record button without manually entering the date?

it was a very helpful thread any way . thx for your time

Replacing 'Date' with 'Get(CurrentDate)' should do it. However, if this file is being shared by multiple users, you may want to script setting the 'id' field, instead of using the auto-enter calculation, so that you do not end up with duplicates.