I've got a website that uses an Access 2000 database and Cold Fusion. I have a Trouble Report form already working but now need to add a unique RecordID to each form for later lookup by user as well as updating by Trouble Team Members. I'd like to make the RecordID a combination of Julian Date, last two digits of year and unique sequential number. This Record ID will show up on a confirmation page as well as be added to the database. I will be designing a search function around this RecordID. This shouldn't be too big of task for the experienced...just too big for me!
## Deliverables
I need the few lines of code to add to my forms as well as the database design structure (ie. new fields, formats, etc.) to be able to make this work. I will provide table as is and coder can add fields as needed. I will also provide existing html (cfml) for entry and action form of website. The code needs to grab the ReportDate (Julian + last two digits of year), stick the last record number to the end of it and make it the RecordID. If the coder has a better way to create this RecordID, I'm open for suggestions. I'd like it to have some meaning if possible so I thought the date was best. A simple increment task? Once it all works, the checks in the mail!
## Deadline information
I've got an end of the year deadline for the whole project so the quicker the better for this segment.