Using SQL Server DB as a datasource

ccondley — Wed, 31 Oct 2012 19:07:57 GMT

I'm going to apologize in advance if something like this has been posted. I looked for a while and didn't find anything...

I have a single database table with repeating data that I want to use as a datasource for my infopath form. For example:

MsgCat

MsgNbr

MsgText

I want the user to select a MsgCat and MsgNumber from drop down lists, then display the text that's associated with it. Problem is, MsgCat and MsgNbr are both repeating fields in the table.

Do I need to create a datasource that is a select distinct query for each dropdown, then filter based on the concatenated result? Or is there a better way?

Thanks!

Chris

SQL Database Integration

Using SQL Server DB as a datasource