Golf Tournament Database
466218Jan 5 2006 — edited Jan 10 2006I run a yearly scramble golf tournament and would like to use a database to document all the people who have shown interest or who have played in the tournament in the past eleven years. Each year I could then use the information stored to send out notices of the upcoming tournament and statistical trends of the tournament.
My first attempt with XE was to create a master table of these players to include a player id, name, phone, email address, and a field for comments. I then created a table for each year of the tournament and included in each yearly table their player id, Name, Team, handicap, score, place, and a yearly memorable comments line. I then join the 11 yearly tables to the Master list by player id and run queries to count how many tournaments each player has made, when they played, if there handicap is changing dramatically each year...etc. After adding 3 of the 11 yearly tables, I have determined what I am doing is to manual. I want to automate and simplify this hobby db any suggestions on how I could create this more logically?
Additional topic items I desire ideas:
I would also like to include a team picture to the yearly tournament. I have read about blobs and there usefulness but not the how tos.
Eventually it would be nice to make the data available on-line for self service queries and to sign up on a yearly basis. I do have internet service which includes up to 6 personal web pages but only 25 MB each. Has anyone done something like this? Any suggestions?
Any ideas on this concept build and what development tools you feel would be best to potentially update these tables and help automate the creation of new tables each year the tournament rolls around would be greatly appreciated. I look at this as I do someone new to golf; by getting the basics correct you can then get creative results with slight variations.
Thanks,
XE DB Novice