By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Access dependent fields

P: 2
Please I am trying to develop a database that filters local government based on state selected. Is that possible
May 10 '18 #1
Share this Question
Share on Google+
7 Replies

Expert Mod 2.5K+
P: 3,158

Welcome to Bytes!

Yes, I think what you are asking, conceptually, is very possible. However, you will have to give us more to go on. What have you tried so far and what aspects of your work are not working as expected/desired?
May 10 '18 #2

P: 2
Please I want to create a table such that when field state is selected local government will be filtered to the selected state. So local government will be determined by state. The project is attached to this post
Attached Files
File Type: zip (37.5 KB, 17 views)
May 10 '18 #3

Expert Mod 15k+
P: 31,307
Let me make it very clear. You will need to put in the time and effort to make your request clearly understood. We are generally uninterested in putting in our precious time and effort simply because members prefer we take the extra time than they do.

You will always know when it's acceptable to offer us your work, because one of us will have asked you first.

Now, Cascaded Form Filtering may be helpful. You may want to look at that first before taking the time to put your question more clearly.
May 10 '18 #4

Expert 100+
P: 1,430
I agree completely with Neopa.

You also should be aware that if a table contains repeating alpha data, it is almost certainly wrong. Your States appear multiple times. Read up about Normalisation. You need another table for the States. Also read up about referential integrity.

May 11 '18 #5

Expert Mod 2.5K+
P: 3,158
This article is a good place to begin learning about data normalization, which is the place to start with your issue. We can assist further if you have specific questions.
May 11 '18 #6

Expert 100+
P: 1,430

I have read numerous Articles on normalisation, and as you know, I am a bit thick.

My basic principal, before one gets to the niceties, is that a table should contain information about a person or object that exists in it's own right.

So an address exists in it's own right. Who lives there is irrelevant.
A person exists in their own right. where the live or their job again is irrelevant.
Jobs exists in their own right. Who does them is irrelevant.

It's not until we set up relationships to tie the person to a job and give them an address that we get a relational database.

I know, it's a very nave approach, but I think it could be helpful for beginners.

May 11 '18 #7

Expert Mod 2.5K+
P: 3,158
Very succinct explanation, Phil! I agree the article I linked my be a bit abstract.... I learned all the principles you mentioned the hard way: by doing it wrong for years until I figured out a better way. You and I both hope to instruct others in order that they might avoid those same mistakes.

Thanks for your work on this forum!
May 11 '18 #8

Post your reply

Sign in to post your reply or Sign up for a free account.