Making a Lookup Table Choice dependent upon a value of another Lookup Table Choice
From the start, I must confess to being an Access newbie so please bare with me, and I may have even posted this is the wrong forum which is further eveidence of my newbieness, but I'm looking for pointers to solve a problem and learn something new as opposed to finding the complete solution. Also I'm from the UK so terms like 'County' might translate to 'State' if you're from the US.
So here is the scenario:-
I have four tables called
Company_Details - contains comapny name, address fields, etc
UK_Country - contains 3 countries of the UK i.e. England, Scotland, Wales.
England_Counties - contains a list of all English counties in alphabetical order
Scotland_Counties- contains a list of all Scottish counties in alphabetical order
Wales_Counties- contains a list of all Welsh counties in alphabetical order
In the 'Company_Details' table is a field called 'Country' which looks up the values from UK_Country table and gives the choices England, Scotland, Wales. There is another field in the 'Comapny_Details' table called 'County'. What I would like to achieve is that this lookup choices for 'County' is dependent upon the selection made from the 'Country' field i.e.
If Country selected is England, The 'County' field shows only the list from the England_Counties table
If Country selected is Scotland, The 'County' field shows only the list from the Scotland_Counties table
If Country selected is Wales, The 'County' field shows only the list from the Wales_Counties table
I'm sure Acees must allow this but I'd appreciate some advice on how to go about this from those more knowledgable and experienced than me.
Valued Forum Contributor
Re: Making a Lookup Table Choice dependent upon a value of another Lookup Table Choice
If you mean Excel and NOT Access then see this link which will explain how to create dependant drop down lists.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By turist in forum Excel General
Last Post: 12-09-2013, 04:21 AM
By formatting freak in forum Excel Formulas & Functions
Last Post: 05-10-2013, 11:35 AM
By PrecisionEngine in forum Excel Programming / VBA / Macros
Last Post: 03-20-2012, 02:37 PM
By amean_n in forum Excel General
Last Post: 06-25-2010, 06:33 AM
By jbitluk in forum Excel General
Last Post: 07-17-2009, 09:46 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1