sydude Posted February 7, 2005 Share Posted February 7, 2005 Hi- Can someone please help me figure out how I can limit the number of times a certain field value can be created for each related record? I have no idea if I'm making any sense, but I'll give you an example just to clarify: I have two related databases. One is a "Users" database, and the other is a "Football Picks" database. The user makes multiple team picks thoughout the season, but the user should only be able to choose each team 4 times in total. How can I limit that? Basically, the calculation or validation needs to be able to stop the entry of a value entered into a field belonging to an individual user to only a limited amount of times. Anyone have any ideas please? Thanks Sy Link to comment Share on other sites More sharing options...
bikergeek Posted February 7, 2005 Share Posted February 7, 2005 You could script the picking process, and have the script check the value of a field which is incremented each time a pick is made, failing if the counter = 4. Be sure to have the increment step only take place after the last opportunity for the user to cancel the pick. Link to comment Share on other sites More sharing options...
aaa Posted February 7, 2005 Share Posted February 7, 2005 You can create free files : Users(with User_Id field), Teams(with Team_id), Picks(which contain User_Id,Team_Id). After your work will be easy and you can resolve your problem. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.