Help with autofill

[JB]

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=9111ef580f95479890fc18fb2c5bac85

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

 

[S.Y.M. Wong-A-Ton]

I've read your post a few times now and still do not understand what your
scenario is and/or what you've tried doing.

You've got two drop-down list boxes, right? One with names and one with
numbers. As I see it, the solution is simple: Fill the first drop-down with
ID+Name and fill the second drop-down with ID+number and then use a filter
(Filter Data button when setting up the data to populate the drop-down) on
the second drop-down to "tie" the ID from the first drop-down to the second
drop-down.

Why are you using current()? Are the drop-down list boxes located in a
repeating table or repeating section?