Access dependent fields

[Ay4rhymes]

Please I am trying to develop a database that filters local government based on state selected. Is that possible

[twinnyfo]

Ay4rhymes,

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?

[Ay4rhymes]

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

[NeoPa]

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.

[PhilOfWalton]

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.

Phil

[twinnyfo]

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.

[PhilOfWalton]

@Twinnyfo

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 naïve approach, but I think it could be helpful for beginners.

Phil

[twinnyfo]

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!