Automatic field entry from another table

[Steve Dorsey]

I have a database with 2 tables and 2 layouts.

I'd like the fields in the second table to auto-populate with data when a selection is made from the first field.

For example:

The first table contains records of personal info

The second table contains fields for listing that info along with other stuff.

My first layout is for data entry for the personal info

My second layout contains a pull down menu for last name, and text fields for first name, and title.

I want the user, when using the second layout, to select a last name from the pop-up list. Then I want the first name and the title to auto-populate using the related data from the first table based on the last name info the user selected.

Make sense?

How would I do this?