I have one table that is full of users and their 20 selections each of Teams.
Then in another table I have point values of these teams.
I want to load the team selections in a table and across from each name I want to call on the score db and I want to pull the point value for each name.
Player 1
Hawks 20
Lions 15
Bulls 23
etc..
Player1's database is in this structure:
Player1, hawks, Lions, Bulls
Score database structure:
Hawks,20
Lions,15
Bulls,23
Where do I begin? I use Dreamweaver and the only thing that remotely works is if I call up 20 different recordsets and have each one filter by a corresponding hidden text fields that equal each of the visible team names. But to get the scores to appear a submit button has to be hit to get these hidden values to migrate to the form var of each recordset.
Am I crazy? Have I confused everyone?
