After changing the user record limit mod to allow only 1 record per week, I got to thinking that it might be okay to allow 2 records per week and, of course, the mod does allow that. However....this database is very closely related to another database I'm running. In that database, users are limited to one record per day; however, it is not with the same record limit mod. It is accomplished by setting each record ID to the user name plus the date (guest04-Jul-2000) so that if there's an attempt to enter another record on the same day, it results in a duplicate key error. I want these databases to share the pass file so users don't have to re-register since the databases are so closely related. Both databases are set up to allow the user to view, modify, and delete only his or her own entries. Will there be a problem created in the first database if I set the add permissions to 2 entries per week in the second database? I know I could change the record limit mod in the first database to match the second but it's working well and I hate to fix what's not broken. Because of the differences (1 record per week, etc), I did create a separate db.cgi file for the new database. The only way in which the first database should be affected is that the permissions would read 1,2,1,1,0 rather than 1,1,1,1,0. So, I suppose, after all this explanation, my question is will that create a problem? Or do I just want too much?

Melanie
http://www.somemoorecats.com/
http://www.okhima.org/

It shouldn't create a problem. The only thing the script checks to see if a person has permission is whether that permission is not equal to zero. If it's anything else, they have add permission.

JPD
http://www.jpdeni.com/dbman/

Great! Thanks! That helps to know, although now that I re-think this, I realize I want to use "week" as one of the variables to graph and having more than one entry per week (or two week 1's, two week 2's, etc ) could make that look rather weird.

Melanie
http://www.somemoorecats.com/
http://www.okhima.org/