That's what I decided on. But then the question arised on which table should it be in- the user table or the group table...I figured it better be the user table since they may be in more than one group.
-----Original Message----- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 5:29 PM To: CF-Talk Subject: Re: Changing access > Actually the admin would open it back up to the original > user to edit/make changes. Why not stick a field in the table storing each bit of info: if null/0, info can only be edited if it's from current quarter; if not, it's the ID of the user who's allowed to edit it at any time. The admin could have access to altering this permission field as and when. - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Get Your Own 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=coldfusionb 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
