I'm making a database for a cricket club. I have a team table where I select a the players for a team in a ceratain fixture. I have also written a query which only shows the players that haven't been selected to play (this is called QryAvailablePlayers). In the team table the only players I can select are those that are available in the QryAvailablePlayers query. The problem that I'm having is when I want to add another fixture with a new team i can't use the players that have played in a various fixture. Is there anyway that I can make everyone available once again when I enter a new fixture.
Update Queries
- Thread starter PR2AledE
- Start date
6 tables
I have 6 tables. the important one being for this for this problem tblFixture which contains all the fixture details, tblTeam which contains all the Players chosen for a particualr fixture and tblAvailable which is based on a update query which updates all the available players.
I have 6 tables. the important one being for this for this problem tblFixture which contains all the fixture details, tblTeam which contains all the Players chosen for a particualr fixture and tblAvailable which is based on a update query which updates all the available players.
