2. ASPRunnerPro General questions
  3. Dependable dropdown menu
This topic is locked

Dependable dropdown menu

 		2/26/2007 1:32:13 PM
ASPRunnerPro General questions
D
 dunga author

hi, <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4710&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
I have a question regarding dependable dropdown menus.
My database contains following tables:
banknotes

..............banknoteID = autonumber

..............continentID = africa, asia,europe, etc.

..............country = list of countries
continents

..............ID = autonumber

..............continentList

..............continentID = africa, asia,europe, etc.
countries

............countryID = autonumber

............countryList = list of countries

............continentID = africa, asia, etc
so, in the countries table every country has a corresponding continentID field
I am lost and do not understand how to link them so they would work like it is shown in the tutorial.<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4710&image=2&table=forumtopics' class='bbc_emoticon' alt=':(' />
ideally, what should happen is that when I choose in Continent for example Africa:only african countries shopuld be available in the corresponding countries dropdown.
I know something is wrong, but do not know what?
Sergey Kornilov admin 2/26/2007

Post or send me two screenshots that show setup of Continent and Contry Lookup wizards.

I'll tell you what is wrong.
D
 		dunga author 2/26/2007

thank you <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=15857&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

here it is :

maindatabase


fields setup


continent table setup


continent table content


country table content


country table setup
D
 		dunga author 2/27/2007

does it really matter if I did or di not setup look up relationships in MDb file? or ASP runner established relationships prevail?
D
 		dunga author 2/27/2007

hi, again.<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=15882&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

I have decided to create a smaller version of my project, as you can see below here is the basic setup of my database in access.
1 database consisting of 3 tables

table1: banknotes, hosting 2 fields: continents, and field two hosting: corresponding countries
table2: continents, hosting continentId, and continents names
table3: hosting: countryId, country names, continentsID (like parameters)


once build and opened in the ASPrunner I have NO problems while setting the continents table Lookup as you can see below.


however, 2 problems arise when I am trying to set the dependable dropdowns.Please check


and


is it much better, where I am wrong?
Sergey Kornilov admin 2/27/2007

ContinentID in Countries table needs to be a Number as it's linked to ID field in Continent table.
D
 		dunga author 2/27/2007

thank you <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=15891&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> it worked.

did it matter for me to link the Id in access or it would have worked without it???