I found this great article on implementing Master Detail cascading drop downs through a browser enabled form.
http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html
However, now I am looking to expand upon this an make my drop downs on my form appear by Consultant Name. Here is a little more information on my form.
I developed a InfoPath form for capturing Time Card Information. The user can select a Client, Project, and Task for each day of the week. I am trying to figure out how to now make the Clients, Projects, and Tasks appear by Consultant Name in my form depending on which Client/Projects/Tasks the Consultant is assigned to in the SharePoint list. In my SharePoint list, I have Clients, Consultants, Projects, and Tasks. In the url above, my Clients are equal to States and Projects are equal to Cities. On my InfoPath form, I have a field called Consultant Name, which is filled out using the Username() function in InfoPath. Now I want the drop downs to appear if the Consultants Name who is filling out the form is assigned in my Sharepoint list to the Client/Project, Task.
Please let me know if you have some ideas on how to do this.
Thanks, Stephanie