Hello,

I have a database called PLAYERS which lists players who participate on
leagues (Player, League). I also have a database called GAMES which
lists results from games played by a certain player in certain leagues
(Player, League, Result).

Now I would like to limit the values for GAMES.Player when the value for
GAMES.League has been given, according to the information provided by
PLAYERS.

For instance, suppose I select "League 2003", and in the PLAYERS databse
there are two players, say A and B, who participate in this league. Then,
I would like to get only two players listed in the list of values for
GAMES.Player (A, B). How can I do this? Is this possible using a simple
query, thus using only tables and no forms, or do I have to use forms for
this?

I do not seem to be able to use the value of GAMES.League of the current
record in setting up a query for the GAMES.Player list.

Also, is this enough to enforce correct behavoir? I mean, what should I
do to make sure that in GAMES only combinations of (Player, League) occur
that also occur in PLAYERS? I only need results from players in leagues
(stored in GAMES) when I know they play in the league (known from
PLAYERS).

Thanks in advance for any reply.

P.S. Maybe you think my database setup is wrong, or if you know a better
way, please let me know - thanks again!