Looking Up Data

[MikeDBMan]

I have 3 fields on my form: ResponsiblePerson, PhoneNbr, EmailAddress. The first one is a combo box populated from another table in the database, personnel. In the Personnel file is the person's name, the field that is also populated on my form. I wish to auto-populate those fields on this form also. I know this is not efficient as I don't really need the last 2 fields in both places but that is how I wish to do it. My question, how do I auto-populate the PhoneNbr and EmailAddress fields of the current from from the other table?

[rpeare]

Is responsibleperson a unique key field? a primary key is one that is never duplicated throughout your database. If this is a text field with the person's name it is probably NOT a primary key because you could have multiple John Smith people names. If it is unique key, also make it your primary key on your Personnel table. Then link the data entry table to the personnel table (going from your data entry TO your personnel table)

If you add the fields you want from both tables then open it and put in a known personnelID (responsibleperson) it should bring up all the information associated with that person. Just beware, you will want to lock these fields down on any form, because they can be changed in this type of setup which you probably do not want.