+ Reply to Thread
Results 1 to 2 of 2

Making a Lookup Table Choice dependent upon a value of another Lookup Table Choice

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Not here, it's rubbish!
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    66

    Making a Lookup Table Choice dependent upon a value of another Lookup Table Choice

    Hi All,

    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.

    Many thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Making a Lookup Table Choice dependent upon a value of another Lookup Table Choice

    Hi
    If you mean Excel and NOT Access then see this link which will explain how to create dependant drop down lists.
    http://www.contextures.com/xlDataVal13.html
    Good luck.
    Tony

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 12-09-2013, 04:21 AM
  2. Restrict choice in List B after making choice from List A.
    By formatting freak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2013, 11:35 AM
  3. HELP! making a table show up by choice. Writing VBA
    By PrecisionEngine in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2012, 02:37 PM
  4. Multiple choice pivot table help.
    By amean_n in forum Excel General
    Replies: 1
    Last Post: 06-25-2010, 06:33 AM
  5. Replies: 4
    Last Post: 07-17-2009, 09:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1