cascading combo boxes

[wjm821]

I can find cmbo1State combo2City. What I'm trying to do is combo2 only show what hasn't been selected.

tblPlayer: fields Player, PositionType, PlayerID(pk)


tblPosition: PositionType, PositionID (pk) nine positions.

cmbo1 selects Player1, cmbo2 selects Catcher when I go back to cmbo1 Player1 cmbo2 needs to show 8 positions

[ranman256]

make a OUTER join query to show positions not yet picked
place both tables in a query, join on POSITION,
dbl-click the join line, set to:
SHOW ALL RECORDS IN t.POSITIONS.

then set the criteria:

(tPlayers.Position) Is Null
to show ONLY the missing positions.

SELECT tPlayers.Position, tPositions.Position
FROM tPlayers RIGHT JOIN tPositions ON tPlayers.Position = tPositions.Position
WHERE (((tPlayers.Position) Is Null));

[wjm821]

Thank you Thank You!!!!!