Populate based on drop-down - HOW?

[Andrey]

I've collected some postings below, showing that it's quite a problem.
The way to populate rows or fields based on selected value from DB is necessary. I want to draw the attantion to this problem. Many of these postings were not answered.

Thank everybody who has an idea how to do this.

Subject: infopath and an access database 6/15/2004 5:45 PM PST
Subject: Populating a SQL DB 6/1/2004 12:09 AM PST
Subject: How To? 6/2/2004 2:18 PM PST
Subject: Displaying single Record in Form when picked from combo box 6/14/2004 11:07 AM PST
Subject: can infopath sync with outllok 2003 6/1/2004 2:17 PM PST
Subject: Re: how can bind DOM to List Box? 6/4/2004 6:31 PM PST
Subject: listbox & database 6/4/2004 2:01 PM PST
Subject: How to fill out sceondary item in one repeat table 6/13/2004 10:22 PM PST
Subject: rePost: HOWTO auto display database data for editing... 6/23/2004 5:52 AM PST
Subject: Displaying data from a dataset 6/7/2004 9:04 PM PST
Subject: display a combo box and several text boxes in sync 6/23/2004 11:57 AM PST

 

[Steve van Dongen [MSFT]]

I've collected some postings below, showing that it's quite a problem.
The way to populate rows or fields based on selected value from DB is necessary. I want to draw the attantion to this problem. Many of these postings were not answered.

Thank everybody who has an idea how to do this.

Subject: infopath and an access database 6/15/2004 5:45 PM PST
Subject: Populating a SQL DB 6/1/2004 12:09 AM PST
Subject: How To? 6/2/2004 2:18 PM PST
Subject: Displaying single Record in Form when picked from combo box 6/14/2004 11:07 AM PST
Subject: can infopath sync with outllok 2003 6/1/2004 2:17 PM PST
Subject: Re: how can bind DOM to List Box? 6/4/2004 6:31 PM PST
Subject: listbox & database 6/4/2004 2:01 PM PST
Subject: How to fill out sceondary item in one repeat table 6/13/2004 10:22 PM PST
Subject: rePost: HOWTO auto display database data for editing... 6/23/2004 5:52 AM PST
Subject: Displaying data from a dataset 6/7/2004 9:04 PM PST
Subject: display a combo box and several text boxes in sync 6/23/2004 11:57 AM PST

If those threads are indeed all related to this topic then I'd have to
say that you have the only subject line that reasonably describes the
question. The 'How To?' subject line is definitely the worst. No
Microsoft people actively involved in this newsgroup are support
personel; all have other jobs they are supposed to be doing and are
volunteering their own time to respond to questions. I can't speak
for anyone else but I'm to busy these days to spend much time here
answering questions. If a post doesn't have a good subject line
and/or it doesn't look like something I can answer well, I'm not going
to read the body of the post to find out what they are talking about.

The Lookup Information samples in the SDK shows how to populate fields
based on some other field value. Selecting a customer ID in the first
view populates the customer details fields in the second view by
getting the values from a secondary datasource. Basically you have an
OnAfterChange event hooked up to the listbox, when a value is inserted
you select the appropriate node(s) in the secondary datasource's DOM
and copy the data over into the primary DOM. If the secondary
datasource doesn't already contain the customer details you can modify
the datasource's QueryString
(XDocument.DataObjects("name").QueryString) and call its Query()
method to load the appropriate data into the datasource.

Regards,
Steve