Propagating fields

[xfwayne]

How do I propagate certain fields? For example, if I want to assign certain addresses, city and state to a school name that automatically brings up the address information when I click on the name on a pull-down menu. In other words, certain database information that are attached to a particular one. On other database apps, I know you use a "conditional" type of field (if/then) but I don't know about Access 2002.

How can I accomplish this on Access 2002?

Thank you.

 

[xfwayne]

Umm...Help?

 

[RuralGuy]

Your question is very general in nature and begs for a response of a ton of questions, which is probably why no one has picked this thread up yet. If you already have a table with the addresses, city, state and school name then use the Wizard to create a form for this table. Then use the Wizard to add a ComboBox to the form that will "Look up a record in my table". That should get you started using Access.