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.