Cascading combo boxes 4 fantasy football

Ramsjammin

New member
Local time
Today, 06:28
Joined
Jan 31, 2005
Messages
5
Hi Everyone

Firstly I'd just like to say HHHHHHEEEEEEEEELLLLPPPPPPPPPPP!!!!!!!!!!!! LOL

I'm creating a fantasy football database for a skool project but have hit somewhat of a stumbbling block with the way to display the team. After discussion with my teacher we decided combo boxes was the best solution (im open to other suggestions) However we cant come up with method to cascade the combo boxes :confused:. I need to cascade the four defenders boxes together, the four midfielders together and lastly the two attackers.

Ive tried to do this using an update query but the problem with that is its updating all the records rather than jus the one I dont no what else i can do and im really hoping one if u's cazn help. Im also tryin to make the user not be able to select more than 2 players from the one team if anyone knows how t create some sort of validation rule for that

Thx alot
Ramsjammin
 
check the FAQ section, there is a good example of cascading combo boxes by Mile-O-Phile.
 

Users who are viewing this thread

Back
Top Bottom