soccer club database

[derlwyn]

I am building a database for my football club.

I have a table containing players details and each palyer has an ID number as a key field.

I also have a team table which stores the 11 players selected for each match.

At the minute it is possible to select the same player many times in the same team.

Is there a way of preventing this?

each player id is entered as a dropdown box using the lookup wizard

thanks

 

[WayneRyan]

derlwyn,

Set the rowsource to the combobox to:

Select PlayerID
From tblPlayers
Where PlayerID not IN (
Select PlayerID
From tblMatch
Where MatchID = Me.MatchID)

That's the general idea, a lot depends on how you have
your forms set up.

Wayne