mistux
asked on
Score sheet entry form for a hockey coach
I am a hockey coach and I need a way to let my volunteers enter the scoresheets on the web. I am Familiar with VBA (I do MS Access programming), but getting new to the web stuff (and also PHP, our server dosen't support ASP).
I have built a MySQL database with the tables and data. What I am thinking is that I need to have a page to prompt for the two teams and how many scores, then post and return a page that has the two teams players "hidden in it" so that when the volunteer goes to enter a score they select the team from one dropdown, then then next dropdown will contain the correct teams player list for them to pick from.
1. I don't know how to make the two teams player list available in the returned page.
2. i don't know how to base the second combobox (player listing) on the first combobox (team listing).
Could you aid in my assistants, please.
I have built a MySQL database with the tables and data. What I am thinking is that I need to have a page to prompt for the two teams and how many scores, then post and return a page that has the two teams players "hidden in it" so that when the volunteer goes to enter a score they select the team from one dropdown, then then next dropdown will contain the correct teams player list for them to pick from.
1. I don't know how to make the two teams player list available in the returned page.
2. i don't know how to base the second combobox (player listing) on the first combobox (team listing).
Could you aid in my assistants, please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Specifically how do you base one dropdown on the first dropdown, i.e. Team then roaster for that specific team?
I imagine that I need an arrow to hold both roasters, but where do I put it (or hide it) so that the dropdowns can get to them?
Thansk.
I imagine that I need an arrow to hold both roasters, but where do I put it (or hide it) so that the dropdowns can get to them?
Thansk.
ASKER
I'll accept this and thank you for your time and trouble, even though my subsequesnt question based on the first question has yet to.
ASKER
1. I don't know how to populate a dropdown list based on the the selection of a previous dropdown list. Example: the Player Listing based on the Team selected. I intend on haveing one form with as many "rows" of this combination as is needed to enter all the scores for one game (as opposed to having just one row and posting it and comming back each time.)
Thanks.