Create a Repeating Cascading List from a Flat Data Source

re: Create a Repeating Cascading List from a Flat Data Source

Rania — Sun, 07 Apr 2013 07:12:31 GMT

is this way supported in SharePoint 2007 server .. cause i got the following error msg.

Filter are not supported..

can you advice me on that

re: Create a Repeating Cascading List from a Flat Data Source

Rania — Tue, 05 Mar 2013 05:01:42 GMT

thanks it works fine with me

cascading

cascading — Tue, 13 Jul 2010 09:23:10 GMT

Pingback from cascading

Repeating tables | keyongtech

Repeating tables | keyongtech — Sun, 18 Jan 2009 17:33:26 GMT

Pingback from Repeating tables | keyongtech

re: Create a Repeating Cascading List from a Flat Data Source

gdgonzal — Tue, 13 Jan 2009 17:54:16 GMT

I am attemtping to apply this to a nested repeating table, I have 4 Regions (North, South, East & West) and a State (U.S.). I want each State group be it Region, it would look like this:

Regions States

South Florida

Texas

East New York

Maine

In order to accomplish this I am nesting the State field within the Region field but this is preventing the current()/my:Region filter from working properly when applied to the State field, it's blank.

Using the method you describe here I am able to get it to look like this:

Regions States

South Florida

South Texas

East New York

East Maine

My question is how should the filter be formatted when you're cascading within nested fields? I tried xdXDocument:get-DOM()/my:myFields/my:Locations/my:Regions/my:Region = current()/my:myFields/my:Locations/my:Regions/my:Region but that does not work either, thanks!

re: Create a Repeating Cascading List from a Flat Data Source

msideek — Sun, 16 Mar 2008 17:33:50 GMT

thx i found the solution

not(. = xdXDocument:get-DOM()/my:myFields/my:Profile/my:Project/my:ProjectId)

re: Create a Repeating Cascading List from a Flat Data Source

msideek — Sun, 16 Mar 2008 16:58:34 GMT

i did all u did and it work good

but i don't want duplicate years in the table

example i have in year list 2000,2001,2002,2003

i want when the user choose 2000

then when he want insert another row he see in the list of year only the years he not choosed before then next list must contains 2001,2002,2003 only if he choosed 2002 then in next list only show 2001,2003 only

plz help me how can i do it

re: Create a Repeating Cascading List from a Flat Data Source

Soham Bhatt — Thu, 14 Jun 2007 04:18:21 GMT

Greg - i just read the blog without repeating table (http://www.infopathdev.com/blogs/greg/archive/2005/07/06/Create-a-Cascading-List-from-a-Flat-Data-Source.aspx). this is exactly what i'm after but having trouble applying the filter on the year button......i have texbox field called 'QuarterField' under the main data source (under myFields). and my secondary data source is a SQL connection with following structure -> myFields/dataFields/d:Index/:Quarter. what would be the filter expression?

re: Create a Repeating Cascading List from a Flat Data Source

Soham Bhatt — Thu, 14 Jun 2007 02:00:16 GMT

How would you achieve the same if the table is not repeating - i have manage the make and model show unquie based on the filter of year and make (respectively) but wondering about the year field.......how would i be able to able to apply the filter on year to show unique values ??