InfoPath Dev

Matt, Thanks for tip on describing and showing schema easily. Okay, I see how your example started with customer ID. But now in the process of working through your example, I have ended up adding 5 more fields to my ''MAIN'' data source definition of ''myFields''. If I understand how InfoPath works (which is questionable at this point ;), ...

Sorry for making this sound confusing. Let me try to simplify my example... The 1st table ''Product'' has 4 fields; productID (an integer), productDesc (text fld), unitPrice (currency), categoryID (integer). The 2nd table ''Product Category'' has 2 fields; categoryID (an integer), categoryDesc (text fld). The 3rd table ''Customer'' has 4 fields; ...

Is there someone who can help address this question?

I have a table ''A'' with 5 fields that correspond to keys from tables ''B'',''C'',''D'',''E'', and ''F''. When InfoPath SAVES data into table ''A'', I only want it to save the keys, yet when my user VIEWS the form, I want them to see ALL of the datafields from the corresponding tables. For example, I want to Store the values 1,2,3,4,5 into Table ...

I am having the exact same issue. I have looked EVERYWHERE I can think of to find the answer. Basically, I saw a demo where something VERY close to what I wanted to do was shown. It was in a MS Webcast where the presenter did not want to retype all of the data, repeating sections, etc., etc. so he had a button labeled LOAD DEMO DATA. When he ...