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!
5  1216 
Oh, sorry. Forgot to mention that I have the latest Access (from Office 365).
In answer to your first question, try reading this article: Cascading Combo/List Boxes. I believe that this is exactly what you are looking for.
Since only one question is allowed per thread, I won't directly answer your other question, but I would recommend that you read Database Normalization and Table Structures as it explains why you don't want to have your database setup in a way that requires what you are trying to do.
zmbd 5,501
Recognized Expert Moderator Expert
Hey,
I'm going to send you my "tool-kit" for new Access programmers. Please check your Bytes inbox.
It has several tutorials and links to things that will help you.
Of particular note will be the concept of normalization!
You can often get around normalizing your database for simple things; however, for what you are attempting you are going to need it!
-Z
Hi Seth Schrock and zmbd,
Thank you both very much for your quick reply! I'll look into it now. Hopefully I can fix it with your tips. And sorry for posting two questions! I didn't know that wasn't allowed.
Cheers,
Ally
zmbd 5,501
Recognized Expert Moderator Expert
The two questions are close... and you are just starting - all good.
I forgot, the boilerplate I pm'd you doesn't cover filtering... especially with cascading comboboxes which you will find usefull...
-filtering- Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Andrea Bampi |
last post by:
I'm just trying to do my first experiments with js, but I need some
good examples to start with..
I need to design a dynamic form with two dropdown menus picking their
select values from a db: my problem is, how can I make the selection
in the first menu affect the value list in the second, without using
any buttons? I mean, you just have to click on the first menu and
select the desired item, then the proper select list is "loaded" into...
|
by: chart43 |
last post by:
I have question about the technique for css dropdown menus described in
http://www.alistapart.com/articles/horizdropdowns/. Based on an html list,
it has a few items in a 1st order list and further 2nd order lists that
appear to the right when hovering over items in the 1st order.
Anyone figured how to modify to go to n order greater than 2? Bit tricky I
found. I could get the other orders but they all appeared when hovering over
the 1st...
|
by: Continental Translations |
last post by:
Can anybody help me? I am trying to create two drop down menus, where the
results of the second one vary depending on what was selected in the first
one. I am using MS Script Editor in MS Front Page to do this.
In my first menu, I want "English" "German" and "Russian."
Now if "English" is picked, I want "French" "German" and "Spanish" to
appear.
If "German" is picked in the first menu, I want "English" to appear"
If Russian is picked...
|
by: Val P |
last post by:
How does everyone design the database access layer in an asp.net application?
Two options that come to mind is:
1. create a database class and instanciate it as needed, local to a function
or
2. Provide database access in a base class from which all objects that need
db access will inherit from.
#1 seems wasteful for application that do frequent but light db access.
Option #2 seems even more wasteful, because it adds overhead to the
|
by: sadanjan |
last post by:
Hi ,
Appreciate if someone can clarify if database Share Memory Limit
(2 GB ) in Unix 32 bit boxes is the top limit for all the databases
put together in a database or is it for each of the database in an
Instance
Thanks & regards
sadanjan
| | |
by: cheng |
last post by:
can anyone give me java codes for dropdown menus for website.....
|
by: goresus |
last post by:
Hello there,
I am trying to create two dropdown menus in one of my forms so that they behave in the following way:
the first menu consists of "categories" of items, which I hard coded into the form. i am looking to relate the second menu with the first one such that, as soon as you choose an option from the first menu, the second menu lists only the name of those items that falls in the "category" chosen in the first menu.
I have a...
|
by: torquehero |
last post by:
Hi all :)
I have created a horizontal navbar using Xara Menumaker. The Menu items have several dropdown menus. Its a javascript. When the mouse cursor is moved over any menu item, a dropdown list/menu appears. When the page is opened in the browser (as it appears by default), the dropdown menu positions are correctly displayed. But when I scroll the page and then move the mouse over any menu item of the navbar, the dropdown menu is not...
|
by: angelinahmaleka |
last post by:
Hi, I have just joined the forum and I need help with Javascrip dropdown menus. I have written a function which should change the background image of a button when it is clicked:
function change(el)
{
if (el.style.background='url(arrow-up-title2.jpg)'){
el.style.background='url(arrow-down-title2.jpg)'
}
if (el.style.background='url(arrow-down-title2.jpg)'){
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
