I have an application where users edit information each quarter. Once the end of quarter date is reached they can no longer enter any data- it becomes view only. On occassion these users need to go in and fix errors in the past quarter(s). I need a way for the admin to open it up for them to edit their material. I'm not sure on the best way to structure all of this most efficiently. Currently: For the people who do data entry: on the display page I have an cfif statement--cfif now between beginning and end of quarter-- show input boxes else view only. So now I need to add more flexibility. I assume I should add a column for this to my database? That is where I lose my thought- should there be a field on the users table for this? And then on the display page how do I make it so that only the selected quarter shows up? Any help/ideas would be greatly appreciated. J
______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
