I have a form created in InfoPath 2003. I am trying to set the form so when
I select the contact name, it also sets the phone number automatically. I
can't seem to get it to work.

The data goes into an Access database called Phonelog.mdb into the table Log

The Name is set to a drop down list that pulls the list from the list
database under the table Faculty name. Under the column Faculty Name.

The phone number is set to a drop down list that pulls the list from the
list database under the table faculty name under the column phone number.

The ID for the faulty table is called ContactID.

When I submit the form the data goes into the log table.

Under the Microsoft blogs, gives instructions on how to do it.
http://blogs.msdn.com/infopath/archive/2004/09/10/227972.aspx

I have followed that and seem to not be able to get it to work.

I have also found a site that gives more detail but that is not working
either. that site is
http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18
fb2c5bac85

The ID for the Log is called ID
The ID for the Faculty Name table is called ContactID

The field for the name under Log is called Name
The field in the faculty name that I am using as a secondary source for the
drop down is called Faculty Name

The field in the log for the phone number is called phone number. The field
in the table faculty name is also called phone nujmber

I would like it to where the phone number automatically populates when I
select the name. I can't get it to work. below is the the rule I entered
using the directions.

../@Name[../@ID = current()]

What am I doing wrong.

Thank you for your time and assistance.

Jesse