datasheet view adding fields drop-down box

[techexpressinc]

I have a access db with 2 tables. Student School
When adding rows to the Student table for the field School the selection is a drop-down list. I want the school address to automaticly populate the Student table for the field School Address on the Student table.


Is this possible and how?
The access db is a small file attached and at
http://www.box.net/shared/7ncxb1u1dg
Thanks Russ @ techexpressinc.com

[techexpressinc]

I agree multiple storage of same data arross tables is bad. The schoolID is being stored with on the Student record, field "Child School" in the form of the School name. For all the reports they DB owners should join the tables together. The users like to just dump/copy tables into Excel and work with the data. The users are not comfortable writing queries or reports.

Can I somehow populate the STUDENT table’s fields: school address, Location, zip code; once they select the school from the drop-down. I think it would be populated with the pointer not the actual data, like the school name is populated with the pointer.

I am very limit part-time help for the DB owners

[dcrake]

What you actually want is a query that has a join between student and school and bring down the address iin your query. Then export the query to Excel not the table. Also using combos in tables is often frowned upon by seasoned users as they can cause all sorts of issues later on.

David