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.