If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filtering list box choices
First let me say that I have learned more from this site than most of the
books i have read. The books only show all the basics. Thanks to everyone who has helped. I am trying to filter a list box, what I want to do is choose a players name in the first list box and have the second list box show the lifts and max weight he has lifted for each lift. This is my set up Tbl_PlayerInformation PLayer_ID (PK) Fname Lname Tbl_CoreLifts Lift_ID(PK) LiftType Tbl_WeightResults Weight_ID(PK) Player_ID Lift_ID LiftDate WeightLIfted My two list boxes are ListBoxNames ( sourcr is PlayerInformation table) Bound by Player_ID to Weight results table ListBoxLifts ( source Core lifts table) I store the lift_ID in weight results table I would like this list box to show only the lifts and weight for the player chosen in the list BoxNames. Should I be using a Query to get the lifts and weights for the players instead of the core lifts table. The core lifts table is related to player information table and shows what lifts each kid has done in the table view -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1 |
#2
|
|||
|
|||
filtering list box choices
Search on Cascading Combos.
-- Build a little, test a little. "Miami5 via AccessMonster.com" wrote: First let me say that I have learned more from this site than most of the books i have read. The books only show all the basics. Thanks to everyone who has helped. I am trying to filter a list box, what I want to do is choose a players name in the first list box and have the second list box show the lifts and max weight he has lifted for each lift. This is my set up Tbl_PlayerInformation PLayer_ID (PK) Fname Lname Tbl_CoreLifts Lift_ID(PK) LiftType Tbl_WeightResults Weight_ID(PK) Player_ID Lift_ID LiftDate WeightLIfted My two list boxes are ListBoxNames ( sourcr is PlayerInformation table) Bound by Player_ID to Weight results table ListBoxLifts ( source Core lifts table) I store the lift_ID in weight results table I would like this list box to show only the lifts and weight for the player chosen in the list BoxNames. Should I be using a Query to get the lifts and weights for the players instead of the core lifts table. The core lifts table is related to player information table and shows what lifts each kid has done in the table view -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1 |
Thread Tools | |
Display Modes | |
|
|