Received: from pheasant.prod.itd.earthlink.net (pheasant.prod.itd.earthlink.net [207.217.121.20]) by hub.org (8.10.1/8.10.1) with ESMTP id e8LHVHs91678 for ; Thu, 21 Sep 2000 13:31:17 -0400 (EDT) Received: from attickswb.mindspring.com (fw-1.pas2.fw.mindspring.net [207.69.129.98]) by pheasant.prod.itd.earthlink.net (8.9.3/8.9.3) with ESMTP id KAA26697 for ; Thu, 21 Sep 2000 10:31:15 -0700 (PDT) Message-Id: <5.0.0.19.2.20000921132629.032fdb60@pop> X-Sender: bcdoyle@pop X-Mailer: QUALCOMM Windows Eudora Version 5.0.0.19 (Beta) Date: Thu, 21 Sep 2000 13:30:02 -0400 To: From: "Brian C. Doyle" Subject: Re: Multiple Index's In-Reply-To: <009401c023f1$5561b0d0$0200000a@doot> References: <5.0.0.19.2.20000921130926.02c2ad30@pop> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200009/172 See if this help the table has userid | date | helped_customers An employ will enter in their userid, the date and how many customer they helped that day. What I want to do is prevent the employees from enter the data more than once a day At 10:28 AM 9/21/00 -0700, Mitch Vincent wrote: > > Hello all, > > > > How would I prevent a user from submitting information to a table once >they > > have already done so for that day. > >The best you could probably do is to go back and delete undesired recoords >at the end of the day because if it is as you said, they've already put the >information into the database. > > > I would need them to be able > > information on future dates as well as have information in the table from > > past dates from that user. > >Not positive what you mean here but just use a date (or timestamp) column in >the table to indicate when the record was added. > > > I am looking for something like insert user_id, date, info where user_id > > and date are not the same... does that make sense? > >Nope, it doesn't -- at least to me :-) > >How about some table structures and some more information, I'm just not >exactly sure what you'd like to do.. > >-Mitch