Using 1 field to pull multiple fields from another form

Using 1 field to pull multiple fields from another form

Hi,

I am very new to this program and I'm hitting a few roadblocks. I'm trying to look up a name on one form, but I need to pull a few items that is in the record into my existing form. For example, in the first form, I am using a look up to find the doctors name that is is the second form. Along with pulling the doctors name from the second form, I want to pull his credentials and city and state into the fields and prepopulate those fields in the first form.

Help!

Thanks!

Trish