Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Programming > Markup Languages > CSS   »   Cascading lookup fields...

 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Nov 16, 2006, 08:56 AM
wideners
New Member
wideners is offline
 
Join Date: Nov 2006
Posts: 2
wideners See this member's comment history on his/her Profile page.
Cascading lookup fields...

Want to use the form frmCardDetails to populate tblCards. Want to select the sport from a lookup field linked to tblSports and then the League from tblLeagues, BUT only displaying the leagues that are included in that sport.

I have looked at http://support.microsoft.com/kb/209595/en-us and can't seem to make it work. Please advise.

My database is attached...

Brice

Attached Files
File Type: zip SportsCards.zip (11.8 KB, 2 views)
Reply With Quote
 
     

Answers
 
 
Old Nov 16, 2006, 09:33 AM   #2  
ScottGem
Computer Expert
ScottGem is offline
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 21,712
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
First, your table structure needs some work. Using text fields, especially names, for primary keys is not recommended. You should use an autonumber field for your PKs. You also should have a table for player and another table for cards, linked on PlayerID. People names should be broken down into at least first and last. I generally use 5 fields for people names. finally, you don't need BOTH sport and league as Foriegn keys in the Cards table. Since the league is specific to a sport, you can get the sport from the link between league and sport.

I don't see where you tried to implement the instructions in that article. There are no comboboxes on that form.

I suggest that you make the design changes I suggested and then try to implement the instructions. If you don't get it to work, then post a revised copy of your database with what you have done and we will try to help further.
  Reply With Quote
 
     
 
 
Old Nov 16, 2006, 10:26 AM   #3  
wideners
New Member
wideners is offline
 
Join Date: Nov 2006
Posts: 2
wideners See this member's comment history on his/her Profile page.
I understand that there are issues. This is just a sampling of the database. I actually tried following the directions on the MS site with the northwinds db and get the same results. I pick the first field and the second field is just empty. Is there something missing from their directions, like row source or something? I don't get it...

Brice
  Reply With Quote
 
     
 
 
Old Nov 16, 2006, 10:54 AM   #4  
ScottGem
Computer Expert
ScottGem is offline
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 21,712
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
I just reviewed the article. It tells you to create 2 combos and shows you how to set the properties for them. It then tells you to add code to set the Rowsource of the second combo.

Since there are no combos on the form in your sample, I have no idea how you tried to make this work or what you did wrong. If you want my help, then you will need to follow my suggestions. Before you can start building forms, you need to get your table structure set correctly. Otherwise you will be wasting time.
  Reply With Quote
 
     


Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
get arraylist fields in listbox kiran_603 Other Software 0 Oct 5, 2005 10:09 PM
maple tree roots and septic fields bozoman66 Lawn & Garden 1 Jun 18, 2004 05:53 PM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 12:48 AM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.