Limiting amount of adding to database
Posted: Mon Mar 08, 2004 4:32 pm
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
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