On Thu, 21 Sep 2000, Brian C. Doyle wrote:
> Hello all,
>
> How would I prevent a user from submitting information to a table once they
> have already done so for that day. 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.
>
> I am looking for something like insert user_id, date, info where user_id
> and date are not the same... does that make sense?
If you want the first data to go through, maybe a unique index on
(user_id, date) would work.
