Hi - I'm new here, and very new to Access. I'm pretty experienced with Excel and VBA, but have come across a problem at work that I know really needs to be solved using Access - so time for me to learn! I'm Googling for as much as I can, but I'm going to get stuck quite a few times with probably simple things! Thanks for your patience ...
(Using Windows 7, Access 2010 btw)
Q1
Say I have a table called Locations that lists Countries and Cities:
USA, Detroit
USA, Chicago
USA, New York
UK, London
UK, Liverpool
UK, Birmingham
France, Paris
France, Le Mans
I then have another table for inputing details on people I know. This table would have columns called Country and City. I've figured out how to make the Country column a "lookup column" so that I can only enter USA, UK or France. But how do I make the City column show only the appropriate list of cities relevant to the country that I've selected (e.g. Paris or Le Mans if France is the selected country).
Thanks!
Q2 to follow later![]()