InfoPath Dev

I'm trying to display data on an Infopath form using grouping. The data is coming from a SQL view. Here's what I'm trying to show: A - Attorney     Joe Smith B - Partner     John Smith     John Doe C - Associate     Jack Smith     Jack Doe So I'm grouping by code, ...

This is what I did for my solution and it works great! Create 4 views in your form: 1 for a Main Menu, 1 for the Query View, 1 for the Data View and 1 for the New Record View. Set your New Record View as the Default form. Go to Tools, Form Options and under Open Behavior, create a rule that switches view to Startup view. On your startup ...