Infopath Dropdown list and Populating other fields with a MOSS 2007List

[RB0135]

Hi All,

I know there are a few posts about this, but I am getting a strange
issue that i hope someone can help me with.

I have a list in MOSS that has my clients names, etc (about 15 columns
in the list).

I created a secondary data connection to this list and populate a Drop
Down List with the "Company" column data. This is working fine.

I created a rule in the DDL to update a text field with the FULL NAME
column from the same list. The rule is a "Set a field's value", the
fieldname to change is called FullName and the rule ends up like:

FullName=@Full_Name[@Company = .] (the dot . was put in when I picked
the Dropdown list field)

The FullName field ends up with a value, but the value of the First
Record in the list, rather than the match that it should be getting.
It doesnt matter what Company I select from the DDL, it only puts the
frst name it finds in.

Have I missed a step? I cant add any code to the form to accomplish
this unfortunately, as then it I get a WEB security error. I cannot
add digital certificates in to get around it, so all has to be done
through the RULES/FILTERING..

Any ideas?

Thanks,
Robert

 

[Swathi]

Hi,
Try the following steps.
1.Put a rule on Full Name field.
2.In that use ‘Set a field’s value’.
3. Select ‘Full Name’ field in ‘Field’.
4.Select ‘@FullName’ from SharePoint list. Click on Filter Data.
5.Select ‘@Company’ is Equal to ‘Your Text box field’.
6.Click ok 6 times to close all windows.

Hope this helps to you.