Pull second field based on first field selection

[gs13]

Hi All,



I have some access experience, but it's been awhile, so am re-learning. I am trying to pull a query or table where I let the user make the selection for the first field, and based on that field, an associated field is also pulled.

I have a database with numerous fields, all associated with kids in a school. Based on which class they are taking, we have a notes field for each class. I want the user to be able to pull the class they want to see, and the notes field associated with it. They are always side by side in the database. (notes to the right of the class).

Any suggestions would be helpful.

Thanks!
gina

[pbaldy]

Like this?

http://www.baldyweb.com/Autofill.htm

[gs13]

Like this?

http://www.baldyweb.com/Autofill.htm

Similar, but each class has it's own column, and then another column next to it with a notes field. Example:

ClassA ClassANotes ClassB ClassBNotes

So if I choose ClassA, I also want to display ClassANotes. Seems like I would have to write an If/Then statement that refreshes the class name/notes field name each time it runs through to check for each class. I was thinking I could create a lookup table with the class and class notes field names, but still couldn't figure out how to get that to help this process. It doesn't help that this is a part time project, and I can only get back to it about once/week. I keep losing ground. Thanks for the help!

[pbaldy]

Your table isn't normalized. If you fix that it should work.

http://r937.com/relational.html

[gs13]

Thank you for the information!

[pbaldy]

No problem and welcome to the site by the way!