Hi I am thinking about writing an app to keep track of basketball stats for fun and learning more about the new features in 7.5. I would welcome any suggestions.
what I am thinking about using 5 Var lookup combo boxes to pick the current players on the court. Then have 5 Speed buttons or images. (when I had 5 images the form loaded very very slow, they were just small basketballs) I want the speed button and matching Var lookup combo box to be highlighted to show which player has the ball when clicked. If I click on a different speed button that will insert a row in a table saying "Player 1 made a good pass to player 2" and highlight the new current player with the ball. * keeping track of the player that made the pass and who got the pass has been a little hard so far, at least to me! I will also have several speed buttons that will say Made a 2pt shot Missed a 2pt shot Made a 3pt shot Missed a 3pt shot Rebound ..... when you click on them it will take the current player's name and insert a row saying "Player 2 made a 2pt shot" It would also be neat if I could have a time clock to track how much playing time someone has in each game but I would have to do a count down clock thing and that is way above my head. Has anyone done anything like this? Is there something else that would be better to use than a Var lookup combo box? Of course I have other columns in the tables for date, team name.... Thanks Marc
