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
. 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. 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
Ive including a sample of my database if anyone wants to have a stab at it
Thx alot
Ramsjammin
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
. 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. 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
Ive including a sample of my database if anyone wants to have a stab at it
Thx alot
Ramsjammin
