Hi,
I've recently been tasked with developing a database to store data which has been collected by a lot of different people. I have quite alot of access experience, but not that much on database development, so I'm learning quite a lot as I go along.
My problem is that I need to keep information about locations. All the data we have has been collected in different villages. Each village belongs to a Parish, each Parish to a Sub county, each sub county to a County, each county to a district, each district to a region, and each region to a country.
What I really want to do is be able to select a country, then in the region list have only regions in that country come up, then when selecting a region have only districts in that region come up and so on. I beleive this can be done using dependent listboxes.
I need a bit of advice on
a) how to store all the location information. Should each village have ALL the other locational information stored in the same table, or should I try to separate out all the different levels of information and then link them together, or should I do it another way?
b) How easy/hard is it to create a form using dependent listboxes? Does this require programming, as I have no programming experience?
I dont yet have all the linked up locational information - I'll have to enter that in once I figure out the best way to store it. At the moment I have separate tables for each administrative unit, but I can change this if it is not the best way.
I really hope this makes a bit of sense to someone as its quite difficult for me to explain!
I'd appreciate any help anyone can give me.
Thanks,
Nicola