InfoPath Dev

I have a Drop Down List that has two categories: Category 1 and Category 2.

I created two data connections, one to connect to Sharepoint Teamsite A's Contacts in, the other to connect to Sharepoint Teamsite B's Contacts. Both contact lists include first, last, full name and email addresses.

Within InfoPath, would there be a way to create an 'if..then' statement to say if category = Category 1 then use Teamsite A's Contacts, if category = category 2, then use Teamsite B's Contacts? If so, where and how would I do this?

The reason I need this is I created a submit button that emails based off of the Contacts so it would be really REALLY helpful for me to be able to use the category to generate the appropriate list of Contacts.

Any help would be much appreciated!
Thanks!

Normally, to accomplish this if..then feature you would use filters. . . . Something like:

give me all the contacts where the teamsite = selected category

-or-

SharePointContacts/TeamSite[. = SelectedCategory]/Contacts/Contact

Obviously the XPath above would need to be modified to your particular schemas, but it should give you a rough idea.

Hi KidThnkr1 and welcome,
I see two duplicate posts from you. I'm guessing this was a mistake. If not, please don't duplicate post. I replied to the other one here:http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=3714