Linking information from a drop down

[bighop]

I'm new to this forum and Access. I'm developing a database for my school (elementary school)

I understand how to do a drop down list. What I need is other fields to be populated with information that relates to the drop down.

For example:

Fields: Last Name First Name M/F Birthday Behavior (memo)
(Drop down) (link to table) (link) (Link to table) (new data field)



I have one table with general student information on it. This table is called students. I am creating another table for behavior. I want to have a drop down list with the students names, which I can do. When I chose a student, I would like their first name, gender and birthday to appear in the remaining fields. I need to link from the student table, instead of retyping it.

Thanks!

[pbaldy]

Does this help?

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

[bighop]

Thanks Paul, I was able to link the first and last names, I'm still a little unclear how to set up so cells populate with related information.

One other question: I have a basic table set up with student information. I also thinking I should have a another parent table, only because our parents may have more than one child in our building.... does that sound like a good idea?