Auto populate fields?

[dgmorr]

Hey guys,

I'm creating a sub form which would have a couple common fields from another table. This form will be used for data entry. Is there a function that someone can show me so that when the user enters in a specific detail, the other fields will populate with the corresponding data? Let me try to visually explain it better...

Table1
Name   Age   Hair
John      2    Black
Jane      3    Blonde

Table2
Name   Mother   Father   Home
John      Lucy      Jack     CA
Jane      Andrea   Stan    OH

Form
Name   Age   Mother   Father   Home
John
Jane

So when the user types in John or Jane into the Name field, Age would be automatically populated from Table1

 

[RuralGuy]

Hopefully, Table 1 has an AutoNumber Primary key field and Table 2 has a Long Integer field as a ForeignKey field along with an AutoNumber field as it's PrimaryKey field. You can then join the two tables in a query that can display all of the fields from both tables.