Advanced Auto Fill In

[vistor]

Hi,

I know how to do the standard look-up to auto-fill in data on a form. This is the problem I have now and am not sure of the best way to do it.

Staff may sometimes teach class or someone from the community may teach. I have created an instructor table and a staff table.

I want to create an instructor form based on the Instructor table and have a combo box to the staff table to auto fill in the name, phone and email fields if the instructor is from the staff. If instructor is not from the staff I want the user to be able to fill in the fields for the instructor table.

Here are the tables:
Staff:
Staff_ID
Staff_First_Name
Staff_Middle_Name
Staff_Last_Name
Staff_Area
Staff_Email
Staff_Phone
Staff_Dept
Staff_Supervisor
Staff_Active
Start_Date
Leave_Date

Instructor:
Instructor_ID
Staff_ID
Instructor_First_Name
Instructor_Nickname
Instructor_Middle_Name
Instructor_Last_Name
Instructor_Email
Instructor_Phone
Instructor_Phone_Ext
Instructor_Fax
Instructor_Address1
Instructor_Address2
Instructor_City
Instructor_State
Instructor_Zip


Can you fill auto-fill in if the fields are not an exact match? I created 2 different tables as there is different information for staff and non-staff. Should I just have one big table?

any tips would be great. Thanks.

 

[Garridon]

This site has the code for what you're looking for.

http://www.mvps.org/access/

Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[vistor]

Sorry, this link doesn't have what I need - that is if you are referring to their zip code example - this is a basic look up, which I know how to do.

I was looking for something for two tables where the field names do not match - as in the example I gave in my post.

Thanks anyway - I will research some more.