InfoPath Dev

Hi..

I'm working on Infopath since two months. I've a problem coming up.
I'm doing with a form which requires to switch views according to the department of the employee who has downloaded the form from the company's sharepoint site. Now i've tried couple of methods like.

1. using sharepoint site lists.
2. using .Net code and using SQL server tables.

But i have struck in both the methods. Because both involve secondary data source and working with them in the code is creating problems. Can anyone help me in guiding anyhow through this.

Is there any way to do this using USER ROLES method. I also tried that but views were not switching. also i'm not sure about the active directory usage. Whether user roles are validated with the intranet's active directory or with some other ( e.g windows server)
Don't know. Please help me.

Thanks in advance.
Arvind

Would you mind giving a little more information in regards to the secondary data source problems you are encountering.

Also, did you ever see this lab -http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_07.asp - Lab 7: User Roles in InfoPath 2003

Please see this thread, and please don't multi-post :)

http://infopathdev.com/forums/topic.asp?TOPIC_ID=1803