Display Name and Value Not Correct

[bluegrassstateworker]

I am using a SharePoint list containing the fields: AgyNum, DeptNum,
Descr, (text fields) Logical1, Logical2, Logical3 (boolean fields).
Using InfoPath 2003, I can access the data but here is my situation: I
have set the value from the data connection to Value: @DeptNum and
display: @Descr. The description is displaying (in preview mode) but
the value continues to display as the description rather than the
DeptNum. Is there a bug with SharePoint lists or is there something I
am overlooking? I am following an example almost straight from my
reference book.

I was also trying to filter the data based on a logical field but I
was not getting the correct listings. I tried the "Logical1 is equal
to True" but I ended up with a blank list although there should be
about 8. Any filtering advice also welcome.

I have lots of Access programming (no InfoPath to now) and I can
easily display one value and capture another but not with InfoPath.
Any words of wisdom to explain welcome!

 

[Paul]

I am using a SharePoint list containing the fields: AgyNum, DeptNum,
Descr, (text fields) Logical1, Logical2, Logical3 (boolean fields).
Using InfoPath 2003, I can access the data but here is my situation: I
have set the value from the data connection to Value: @DeptNum and
display: @Descr.  The description is displaying (in preview mode) but
the value continues to display as the description rather than the
DeptNum.  Is there a bug with SharePoint lists or is there something I
am overlooking?  I am following an example almost straight from my
reference book.

I was also trying to filter the data based on a logical field but I
was not getting the correct listings.  I tried the "Logical1 is equal
to True" but I ended up with a blank list although there should be
about 8.  Any filtering advice also welcome.

I have lots of Access programming (no InfoPath to now) and I can
easily display one value and capture another but not with InfoPath.
Any words of wisdom to explain welcome!

I have run in to a few items of interest, depending on your list make
sure that everything you are trying to pull in the data connection is
available in the sharepoint view. Also, the filtering works ok but is
more effective to reference values in the data connection and avoid
using any typed in value due to format inconsistancies. A logical test
to display a value should work fine but try to avoid typing in a
value, even as simple as True/False, as I've had many problems between
the formats. Are you typing in values or selecting from the list in
Infopath? Just wondering, there is a way to write an expression for
the filter I'm just curious how you are doing it.