Page 1 of 1

Limiting amount of adding to database

Posted: Mon Mar 08, 2004 4:32 pm
by James138
Hi,
I'm trying to get my database so that you can only update the table a number of times. I have got a table with MemberID, CompetitionID, CompetitionTimes. I need to be able to add no more than 4 membersID per time on. At the moment Im inserting a memberID with a competition time, and i can do this x amount of times. But i want to limit this to a maximum of times per competitiontime. Is there a way of soing this??

Cheers

Posted: Mon Mar 08, 2004 5:00 pm
by James138
What basically i need is that I can assign memberID with a competition time update to database. Where the competition time cannot appear more than 4 times in the database. Is there anyway i can do this?

thanks