InfoPath Toolkit for VS and Master/Detail view with SQL

K

kfrost

Hello,

I'm trying to create a form called triplog. I have a SQL db that has 3
tables. Trips, Fuel, Mileage.

Trips has a primary Key Trip ID that is linked to all the other fields.

My main view I have a secondary list datasource that populates a table with
high trip info. I also have a button to the left of each item when clicked I
would like to bring up a Trip Detail view for all the detailed information
about the trip. I need the info pulled from all 3 sql tables with the option
to also format the data as well.

I've searched and searched for documentation or example on how to do this.
All I can find is an example in the SDK which is using a xml file. THen you
have the DataInterop example however, it's created using script plus you
can't see the info in a lot of the views because I suppose the xsl files were
manually coded and it's difficult to sort through with the poor documentation
associated with it.

My question is does anybody have a simple code example of what I'm trying to
do? Or are there any good books or examples out there of using building and
programming Infopath projects in Visual Studio?

Any help would be greatly appreciated!
 
Top