Avatar of runelynx
runelynxFlag for Denmark

asked on 

Why cant I filter a repeating table using a Sharepoint list in infopath 2007?

Hi,

I'm using infopath 2007 and sharepoitn 2007 (no infopath form services). The compatibility mode in infopath is NOT set to browser-enabled.

When I create a repeating table and connect it to receive data from a sharepoint 2007 custom list, the option to filter that data (on the display tab in the table properties area) disappears...  so essentially it will only return ALL records from the list.

That is not really desirable... I want to filter it based on the value of another control in the form, which seems to be what infopath is designed to help with.

What am I doing wrong? :(

Andrew
InfoPath

Avatar of undefined
Last Comment
runelynx
Avatar of runelynx
runelynx
Flag of Denmark image

ASKER

It also appears that master/detail control functionality is disabled when I'm linking to my sharepoint list (in a receive data secondary data connection)

is this intended?  does infopath just hate sharepoint custom lists?  that seems crazy!
ASKER CERTIFIED SOLUTION
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of runelynx
runelynx
Flag of Denmark image

ASKER

Perfect, that does exactly what I want... thanks again clay :)
InfoPath
InfoPath

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

2K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo