Hi everyone!
I'm doing research for my thesis and need an access database to manage everything. Only, the problem is that the Access courses I had were very basic and 'follow these steps' without requiring actual thinking so I have no idea on how to proceed. I've tried looking it up on Google but found that I couldn't follow most of the answers. Which is why I'm posting here in the hope someone can help this access noob :)
My thesis is on human skeletal remains from Bolivia. So, for each skeleton I'll need to have information on where it comes from. I started by making a table which contains all of Bolivia's departments (Table: Bolivia Departments). In this table, the primary key is the department's name (as it is a unique name).
Then, I made a table which contains the provinces of each department (Table: Bolivia provinces). Here, I made the province name the primary key, and arranged it so that I could choose from a drop-down list which department it belongs to (with the lookup wizard).
Now I want to make a table where I can add the individual sites my skeletons come from. Handy would be here that I can choose which 'department' and then, based upon which department I chose, only get the list of provinces in that department. So that's two drop-down menus, one with departments and the other with provinces. How can I arrange this?
Another thing I'd like to ask is whether it's possible to auto-fill certain boxes based upon what you fill in on one box. For example, some skeletons come from the same archaeological site and thus have the same contextual information. I'd like to have it so that when I choose a certain context (eg. comes from site XXX), that for example the date of that context (XXXX-XXXX BC) and some archive information (eg. 'excavated by XXX) gets filled in automatically.
Sorry for the long list and sorry for my complete inexperience. Hope someone can help me out :)
Cheers!