New Record - Prefill Fields

[emPower]

I have an InfoPath form that has a database as the primary data source. When
I click the Run Query button after putting in a search field, I get the data
back from the DB correctly. However, when I click the New Record button, I
get blank sections on the form waiting for me to click "insert item". What I
need to do is to 'pre-load' these items with 'standard' DB records from the
DB tables. The 'pre-loaded' items reflect default entries for a 'normal'
form. The user can then modify fields on the 'pre-loaded' items and even add
additional items as needed. I am guessing I need to override the script (I
know VBscript but not Jscript) of the default 'New Record' button somehow and
'get and load?' data from the corresponding DB tables, but how? And is there
multiple ways to do this?

 

[S.Y.M. Wong-A-Ton]

Try this article I wrote:
http://enterprise-solutions.swits.net/infopath/programmatically-add-db-record-vbscript.htm

The solution uses views, but you can modify it to use sections for your
case. The pre-loading you can do with rules on the New Record button that
will set the values of the new record fields to corresponding fields from the
Main DB connection with a filter on an ID or something that can retrieve your
default values record.

 

[emPower]

This appears that it will do exactly what I need it to do... Thanks for your
help!