Autofill Question

[Claw D]

Hi all, newbie question here.

I'm working on a to-do list to keep track of my design jobs. I have created a separate table for contacts with: FIRST NAME, LAST NAME, EXTENSION, DEPARTMENT and a SERIAL ID number. The SERIAL ID is also in the main table, and used to relate that table to the contact table.

The last name field is set to auto complete, and I would like to have the other three fields fill in with the correlating information from the same contact record.

The contact fields exist as portals on the main input layout.

So here are my questions:

How do I get The FIRST NAME, DEPARTMENT and EXTENSION fields to populate with information from the record in the contacts table that correlates to the last name?

How do I handle duplicate Last Names?

Thanks in advance for your help.

Dave

*****UPDATE*****

Ok, so far I was able to find out that if I link the Contacts and the Main table with the Last Name field, Then place the Last name field from the main table on the layout, (with the rest of the info being portal fields) the data pops into the portal fields as soon as I deselect the last name field if the record already exists.

I am still wondering how to handle duplicate last names.

Also, The auto complete won't work for the last name. I'm not sure how to fix this.

Any help would be appreciated.

Thanks