I want to have a table which basically stores a location, an area, and a description.
I have a second table with a list of locations.
Areas are specific for each location.

Basically in my main table I want to choose a location from a lookup, which them populates the second lookup with corresponding areas. I then add a description.

Can anyone give me ideas on how to do this or know where I could find example code?

If I understand what you are saying, search the forum for 'cascading lookup'. There is a lot of information here on it.