I have a PlayersInfo table and a Tournaments table. The Player selects a tournament that is then entered into a TournamentsEntered table. Player can only see his info as it is Linked with a LoginID from the Login table. Apart from the Dependant field problem Im still trying to sort out, this works fine.
Now my need:
I've created a different folder where admin logs in. Here I want a table that shows all the Players that Entered for a specific tournament. IOW the Login field will be used to draw the Players that entered for say Competition 3.
I've tried a master detail relationship where the master is PlayersInfo and the TournamentsEntered the details. My problem is now that it shows each tournament seperate and on the link the one specific uset that entered.
I want the result to be:
Tournament 3 (Master table fine, as you can see the details):
Then the details listed:
Player 1
Player 2
Player 3
Player 4
etc.
Maybe need to join or somethng. My only related info is LoginID!
PLEASE HELP WITH SOME ADVICE! - I'm struggling!
Buld 218