InfoPath 2003 Query Function Question

[BenBen]

Hi,

I have a form that is basically going to be used as an interface to query a
SQL table for relevant rows per search criteria. The question that I have
deals with the way the relevant rows display on the form if it meets the
search criteria. The table in this situation has a many fields that are
categorized into 5 "request types" and some admin fields. Basically, all
rows will have values for the admin fields, but from that point on the fields
that are populated are based upon the "request type" of the record. How can I
have Infopath display the fields that all rows contain data and only display
the field values of the requested type of that row?

Thanks a lot.

 

[Swathi (GGK Tech)]

Hi,
Add a button to your form. And after entering the request type value in
search criteria, click the button. In the button click event, write the query
to get the rows by filtering request type entered. After getting the rows set
those values to a repeating table. For this go through the following link.
http://www.developerfusion.com/arti...path-fields-with-sql-data-using-managed-code/