Interesting database. Your question(s) though are kind of vague but it sounds like you would continue down the same path your going with relationships (i.e. create a Game table, not sure about what are red cards), but then you could have another table linked to the Game table which records who played in the game (person ID) and length of time, etc....in regards to randomize (not sure what you mean here which may mean why you haven't gotten many responses), but these could also be tables linked to the Game table (Game table would kind of be your main table on the top of the pyramid). There is code to randomize numbers (you can google this) which will give you randomization if that's what you're looking for. Lastly League tables. Again, I'm not that familiar with soccer and so I can't help you much but from what I've seen that you got so far, you're on the right track and just need to keep thinking down those same lines - perhaps if you explain what you mean by leagues and a little more detail on the other subjects you may get some ideas - right now, it seems very vague and open to all kinds of interpretation (i.e. get more specific - I want to track this here and this here and this there and this there). Hope that helps in some way. But overall, good start and I think you'll do fine if you keep thinking the way you are. Cheers.
Last edited by pkstormy; 12-04-06 at 18:07.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)