InfoPath Dev

I have tried to accomplish this myself, but upon execution all I get is the first entry in the selected column and nothing more.

hi Vinnie,

i think u r simply comparing the value of the selected field in the repeating table,

Can you attach the xsn, so that we can see what we can do.

My boss thinks I’m smart, I would be lost without this forum.

I don't think your explanation makes sense, and I think you're confusing rows with columns.  You twice said that you want the user to select something in a column and then show all the rest of the items in that column.  That doesn't make sense to me.  Columns are nothing but individual pieces of metadata that describe a record.  Each selection in your column corresponds with a record in that list. When you select ONE item from that column, you can then show all the rest of the columns associated with that record, but there is no association between that one record and all the other records that correspond to the other items in that column.  When you attach a dropdown to a specific node (column), then what you are doing is showing each RECORD that exists but only the data in that one column.  When you select ONE of those records, you then only can reference and display the rest of the columns for that one record.

It doesn't make sense to me that you would want to show all the items in a COLUMN, because columns aren't records but rather metadata to describe records.  Maybe you meant to have everything in your column as a row instead?  Anyway, the way you've described it doesn't make sense to me, so please describe EXACTLY what you want to accomplish...not what you want the form to do, but rather your business problem that you're trying to resolve.

So here's the deal.  Do this so that you see what I mean.  In the Data Source pane, select your secondary data connection that connects to the SharePoint List.  Drill down to the REPEATING GROUP that contains your nodes (columns).  Drag that repeating group onto the canvas and preview the form.  You will all the columns and all the rows from the list.  If you only want to show one column, then you simply remove the other columns from this repeating table, or you only drag the one node to the canvas.  This is how you show all the items within a column, but that still doesn't make sense.  Why would you be trying to choose a column to display?  You typically choose RECORDS within your list (aka table, aka database), because the record is the real data, and the column is just one descriptor of the record.

PS.  There is no MOSS 2003.

Hi:

Copying repeating data from a secondary data source into a main data source is possible 2 different ways:

1. Write custom code. When the user selects either Mon or Tues from the first dropdown, you could use the changed event and get the data from the correct field in your secondary data source (Mon or Tues, as the case may be) and then create and populate repeating fields in your main data source
2. Try qRules. It is still FREE, and you may be able to use the CopyTable command and do this without code. You'd have conditions on your rules for the command, so if the value of the field was Mon, you'd copy from one field in your secondary data source into your main data source, if it is Tues, another, etc.

Your help has been invaluable in the past Hilary, thank you. Copying the repeating data from my secondary data source into my main data source is exactly what I am trying to do. So far I have had no luck. I am not a programmer so writing code is way beyond me, and I cannot install qRules on my computer as I have insufficient privileges. MY IT department doesn’t trust anything without the word “Microsoft” stamped on it. I had hoped there might be a simple way to do what I need, or adapt someone else’s JScript to my form. I will keep tinkering with it for a while, but I’m just going around in circles.

Are you using InfoPath 2003 or 2007? If 2007, I'd suggest you use VSTA and C# code -- I find it MUCH easier than JScript. Here is a fantastic article by S.Y.M. Wong-a-Ton that might help you get started....

Thanks for the reply Hilary, I looked at the article by S.Y.M. Wong-A-Ton and it seems to be exactly what I am trying to accomplish, however there appears to be multiple errors in his code, or I am not following his instructions closely enough. I am using IP 2003, and followed the instructions using Visual Basic to no avail. Does this code not work, or is it just me?

I am Having Infopath form where i am having LeadId....while selecting LeadId from dropdown List....I am getting value in the repeating table the problem is that it only show first value .....i have to manually select second value from insert  option  and so in  repeting  table.it is possible that i should get all the value in repeating table. although i have issued CAML query for that....so here are my code .....thank's in advance if one can help.....

using Microsoft.Office.InfoPath;

using System;

using System.Windows.Forms;

using System.Xml;

using System.Xml.XPath;

using mshtml;

using Microsoft.SharePoint;

public partial class FormCode

// Member variables are not supported in browser-enabled forms.

// Instead, write and read these values from the FormState

// dictionary using code such as the following:

//

// private object _memberVariable

// {

// get

// {

// return FormState["_memberVariable"];

// }

// set

// {

// FormState["_memberVariable"] = value;

// }

// }

// NOTE: The following procedure is required by Microsoft Office InfoPath.

// It can be modified using Microsoft Office InfoPath.

XPathNavigator secDSNav = DataSources["CustomListCAML2"].CreateNavigator();

int methodNodeCount = iter.Count;

XPathNavigator root = MainDataSource.CreateNavigator();

XPathNavigator QDF = this.MainDataSource.CreateNavigator();

string QuotDate = QDF.SelectSingleNode("/my:myFields/my:ddlDate", NamespaceManager).Value;

string CustomerName = QDF.SelectSingleNode("/my:myFields/my:txtCustomerName", NamespaceManager).Value;

string ContactPerson = QDF.SelectSingleNode("/my:myFields/my:txtContactPerson", NamespaceManager).Value;

string VAT = QDF.SelectSingleNode("/my:myFields/my:txtVATAmount", NamespaceManager).Value;

string ForwardCharges = QDF.SelectSingleNode("/my:myFields/my:txtFORWARDINGCHARGESAmount", NamespaceManager).Value;

int counter = 1;

string Desc = rows.Current.SelectSingleNode("my:txtItemDesc", NamespaceManager).Value;

string Rate = rows.Current.SelectSingleNode("my:txtRate", NamespaceManager).Value;

DataConnections["MainSubmit"].Execute();

System.Text.StringBuilder sb = new System.Text.StringBuilder();

sb.AppendFormat("<Field Name=\"Title\">{0}</Field>", QuotNo);

sb.AppendFormat("<Field Name=\"LeadID\">{0}</Field>", LeadId);

sb.AppendFormat("<Field Name=\"ContactPerson\">{0}</Field>", ContactPerson);

sb.AppendFormat("<Field Name=\"ProductName\">{0}</Field>", ProductName);

sb.AppendFormat("<Field Name=\"Qty\">{0}</Field>", Qty);

sb.AppendFormat("<Field Name=\"Amount\">{0}</Field>", Amount);

sb.AppendFormat("<Field Name=\"VAT\">{0}</Field>", VAT);

sb.AppendFormat("<Field Name=\"ForwardingCharges\">{0}</Field>", ForwardCharges);

sb.AppendFormat("</Method>");

string leadid = Demo.SelectSingleNode("/my:myFields/my:ddlLeadId", NamespaceManager).Value;

                "<Where>" +

                                 "<FieldRef Name='Lead_x0020_Id' />" +

                              "</Value>" +

  "</Where>";

string myNamespace = NamespaceManager.LookupNamespace("my");

writer.WriteElementString("txtItemName", myNamespace, item.Title);