InfoPath Dev

I am trying to display multiple columns from a sharepoint list based on a filter of another field in the InfoPath form.

 Two questions:

1.  What control should be used to display the column in the form?
2. How to display each column in its own control?

Sample data:

 The filter is on the Job Title and I want to display the SOPs.

 Thanks,

Sean 

One idea would be to filter using Owssvr. Here are some articles that may help:

http://vspug.com/dwise/2008/01/10/accessing-sharepoint-list-data-as-xml/

http://geekswithblogs.net/PsudoKnowledgeBase/archive/2010/02/01/using-owssvr.dll-to-filter-sharepoint-data-on-the-server-side.aspx

http://www.bizsupportonline.net/blog/2009/07/pre-filter-large-sharepoint-list-infopath-wss-owssvr-dll/

Of course, one option is to do the filtering in InfoPath itself, but if your source data is large then this will slow down the form considerably. We have previous threads on this, such as this one:

http://www.infopathdev.com/forums/p/9329/33038.aspx

Good luck!

Hello let me explain it step by step

1. create a text box control which will be bound to job title

2. create a repeating table section which would be bounded to the other fields you wish to display

say SOP1 , SOP2 , SOP3 etc

3. create a rule for each SOPs and add a filter to select them only when the secondary title matches to the database title