I am trying to design a simple form that shows a list of counties.
When the user clicks on a county name I want a list of towns in that county to appear (or drop down).

I assume I need 2 tables:
County_Names and Town_Names

I'm unsure how to link them together or how to get one list to activate the other.

I have some programming knowledge but I'm new to Access, I'd appreciate any advice.
Thankyou
Bob B.

You do need two tables.

tblCounties
CountyID
CountyName

tblTowns
CountyID (use Lookup for data type and refer to tblCounties)
TownName

You can create a form based off of tblTowns. On that form use the toolbox to creat a combobox. The wizard will walk you through. You need to select Option 3 "Find records based on my choice". The fields you will need are from tblCounties. The fields are CountyID and CountyName.

Put the other fields from the field list on the form, town name...

You will see them change as you change your combo.

Good luck.