Hi
I have two tables, Results and Assignments
Results has the following fields
Week (With selections of Week 1, Week 2, Week 3, Week 4)
Winner
Loser
Wins
Losses
Assignments has the following fields
Week (With selections of Week 1, Week 2, Week 3, Week 4)
Player 1
Player 2
I have a script to display ALL assignments
I have a script to display all results
What I'd like is a script that shows who has not posted match results for assigned matches. (Backgammon League)I'd need a script to display Assignments that do not have a Results posted for them in the Results table.
Example
Assignment Table
Week Player 1 Player 2
Week 1 Tom Jerry
Week 2 Ed Tim
Week 3 Josh Salvador
Week 1 Sue Nancy
Results Table
Week Winner Loser Wins Losses
Week 1 Sue Nancy 2 1
Week 2 Ed Tim 3 0
The Script I would like would then show unplayed matches
Week Player 1 Player 2
Week 3 Josh Salvadaor
Week 1 Tom Jerry
Thanks for any help on this
I have two tables, Results and Assignments
Results has the following fields
Week (With selections of Week 1, Week 2, Week 3, Week 4)
Winner
Loser
Wins
Losses
Assignments has the following fields
Week (With selections of Week 1, Week 2, Week 3, Week 4)
Player 1
Player 2
I have a script to display ALL assignments
I have a script to display all results
What I'd like is a script that shows who has not posted match results for assigned matches. (Backgammon League)I'd need a script to display Assignments that do not have a Results posted for them in the Results table.
Example
Assignment Table
Week Player 1 Player 2
Week 1 Tom Jerry
Week 2 Ed Tim
Week 3 Josh Salvador
Week 1 Sue Nancy
Results Table
Week Winner Loser Wins Losses
Week 1 Sue Nancy 2 1
Week 2 Ed Tim 3 0
The Script I would like would then show unplayed matches
Week Player 1 Player 2
Week 3 Josh Salvadaor
Week 1 Tom Jerry
Thanks for any help on this