.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

BCS many-to-many and InfoPath

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint


We have the following tables:


One link table (ProductGroup_Product) which supports that one product can be included in many groups. We have exposed these tables using external content types. We want to be able to modify this product in InfoPath and select one or more groups on each product. The External Content Picker supports multi select. We want to try Scots last suggestion here


i.e. expose a Finder operation on ProductGroup_Product which returns all groups for a specific product. I have spent quite some time trying to get this work in InfoPath without any luck. How to pass in filters on ProductId? How to update the link table? What about new products that doesn't yet have a ProductId when submitting?

Has anyone stumpled across a good article that describes how to do this? I've seen quite a lot of questions without answers and this seems like a faily straight forward scenario in most systems.


View Complete Post

More Related Resource Links

InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

InfoPath 2007: Designing Form Templates With The New Features Of InfoPath


InfoPath 2007 is an XML forms designer and editor, and a fully featured and integrated member of the Office family. This article takes a sneak peek at some of its new features.

Scott Roberts and Hagen Green

MSDN Magazine August 2006

Inside MSDN: Using InfoPath as a Reporting Solution


I love the part of my job that lets me write code and develop software. In addition to those responsibilities, however, I manage a development organization that's working on a number of large strategic projects.

Larry W. Jordan Jr.

MSDN Magazine March 2005

InfoPath: Turn User Input into XML with Custom Forms Using Office InfoPath 2003


Office InfoPath 2003 is a new Microsoft Office product that lets you design your own data collection forms that, when submitted, turn the user-entered data into XML for any XML-supporting process to use. With an InfoPath solution in place, you can convert all those commonly used paper forms into Microsoft Office-based forms and end the cycle of handwriting and reentering data into your systems. Today organizations are beginning to realize the value of the mountains of data they collect every day, how hard it is to access it, and are striving to mine it effectively. InfoPath will aid in the design of effective data collection systems. Here the author shows you how to get started.

Aaron Skonnard

MSDN Magazine September 2003

Infopath and Section 508 Accessibility


Hey, guys! I'm building a web site for a Section 508 workgroup, and I need the site to be 100% accessible (including the administration module I'm making for the team. We're using SharePoint MOSS 2007 and I recommended using infopath to enter data into the site's database (and also to populate downloadable Microsoft Word documents). The customer claimed that InfoPath is not Section 508 compliant, which seemed odd to me because the forms can be modified to anything you want them to be (including 508 compliant).

I even found this guide to making InfoPath accessible:


I'm curious if there are any caveats to making accessible forms in Infopath, or if the information I've gathered is incorrect.



Proper setup using Infopath and Custom Workflow using VS 2008



I have been struggling for a couple of days, trying to set up a decent
structure for an Infopath project using a custom workflow using Visual Studio 2008.

I had a solution with two projects:

1) Sharepoint 2007 Workflow

2) Infopath 2007 form w/code-behind.

I included the xsn, in the VS solution, but after a day or two,
something went wrong, and I lost some work. I still do not know what
happened, but I could not get my changes to persist afterthat  Doing research I have read that this
stucture, using Infopath xsn, within VS does not work correctly with Source
Control. I am using VSS.

So I since made a change to the set-up so that the .xsn (form template) is separate from
Visual Studio. However, I need to leave the code-behind in VS, since I need to debug

This is my latest problem. I have been unable to attach to the correct
process, as VS generates cachse files, and who knows what else.

My question is simple. What is the supported method for debugging InfoPath
code/behind, which uses a Sharepiont Workflow?

I just also want to say that one should not have
to spend a few days just trying to setup a working development environment.

This should be trouble-free, but it is far from being so. I

Using Infopath form fieldnames in a workflow fails



I designed a form in Infopath and I published it on a SP2007 server to use in a workflow in a library. That goes fine. In the workflow I send an email message. I can use the fields from my Infopath form in the message that I create. 
If the workfow is starts, Shrepoints sends me the message. But it does not use the fields from my InfoPtah form in the message in stead I see questionmarks.

Why doesn't it show the fields?

I alse saw (maybe this makes it clear) that when I let it dipslay the URL in the message, it show: http://1.portal.lucasonderwijs, but the actual site is whithout the "1" and it should also start with https://

Has anyone seen this before?

Thank you,


InfoPath Workflow Task Form "Loading" event handler only being called after App Pool recycled.


I have a Workflow that is using an InfoPath task form.  In the "FormEvents_Loading" method event handler I have some code that needs to run each time the form is opened.   I recycle the App Pool and open the form the code runs perfectly, but if I close and try to re-open the form the code is not run at all.  I can then recycle the App Pool again and on the next load the code executes just fine.   The code that is supposed to be run is a very simple statement to set a field value, so I don't think it is interfering.

Does anyone know what this might be?


MOSS 2007 : I am looking for tutorial about how tu use infopath 2007 forms and to associate to them



I am quite new on sharepoint 2007,

i am at the moment looking for tutorial to help to understand better the concept of workflow you can associate with infopath 2007.

I would like to create a  form that the visitor of the website can fill and then submit.

once the form submitted i would like tto be able to store all the date picked up to the database sqlserver 2005 and then to be able to send a email to the administator to be kept inform  of that.

the 2 tutorial i found that i found interested are http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx and the microsoft one o.n the virtual lab.

So what i am looking for is any tutorial which can help me to be understand very well how to use the worklow with infopath or if you have as well some book to advice me for that i would be happy.


Problems moving an InfoPath form from a DEV system to QA environment


We developed an InfoPath form using a local DEV environment.  The site collection under which the form was developed was http://server1/.

We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely http://server2/sites/sitecol1.

In both cases the site that contains the form is /fin (so we were using http://server1/fin in DEV and want to use http://server2/sites/sitecol1/fin in TEST). 

The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:

1. Publish the form against the TEST server using InfoPath Designer

2. Upload the form using Central Administration > Application Managment > Manage Form Templates

3. After upload, we activate the form for the site collection http://server2/sites/sitecol1/

4. The form is then associated with a Form Library

When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:

The following location is not accessible, because it is in a differ

Infopath cannot load this form. Either the signature is corrupted, or the certificatie used to sign



I have a whole bunch of forms contains errors like whenever you try to open it up.

Infopath cannot load this form.  Either the signature is corrupted, or the certificatie used to sign this form is expired or revoked.

The forms were orginally created with digital signature with it.  But we were in the middle of transition from one company to another company.  The digital signature was no longer valid.  Actually, the certificate should have been expired by now.  I removed all the signatures for all of the forms.  So they can continue using the forms to fill in the information.  The problem right now, is trying to open the old forms with digital signature on it.   Not only the company has changed.  We also moved sharepoint from the old server to the new server.

Any idea to resolve th

how to add vailidation between library field and infopath


 i have a browser enable form with filed mails ids and cost i am promoting these filed, and it's saving in library  but i need a vailidation when if any when to submit  requets using mail and cost , at  time i need availidation that your mail id is already  exit , i create a receiving connection for mail id fields it received fileds how to i compare it


Insert image into Infopath form and save to SharePoint as PDF file


I have an InfoPath web-enabled form in MOSS 2007, that is integrated with a K2 blackpoint process for an approval workflow.

Once the form (a Purchase Order request form) has been approved in the K2 workflow process, I switch the form view to a "print-friendly" view for the requestor to view from the browser.  However, now I need to go one step further with this scenario:

1) I need to somehow insert/embed an image with the scanned-in signature of the approver (likely stored in a SP doc library) at the signature line section of my form.  Also, what are the security requirements for storing such images, but not granting all users access to these (e.g. only services accounts that need to access this for embedding into the form, etc.)?

2) Then I need to convert this final "print-friendly" view of the form (with the signature image) to a PDF document so that I can store it in SharePoint (and email it to the requestor using K2's email event capabilities).

Can anyone help me with a solution to both of these requirement, or point me to some resources for this (even 3rd party components are open-game).



InfoPath form checked out so 'on create' workflow not being started


Hi all,


I have found a couple of threads asking for advice on how to check in an InfoPath form when it’s saved or submitted to a forms library. The reason for doing this is so a workflow can start based on a new item being created in that library, and so it doesn’t just sit there with a “Starting” status.


The answers I have found contradict each other:

·         You have to do it with a workflow.  This can be done easily with SharePoint Designer if that's an option for you. Source:

Error when opening Infopath Form


Background: Created an Infopath 2003 form with 2 views (1 as Read-Only View and another 1 for Submitting content) and published to a Sharepoint 2007 Library.

Working: When a user opens a new form it opens in submit view; once the form has been submitted, when the user tries to open again, the form opens in read-only view.

Error: 99% of the users do not face any issues, however when the the rest 1% of the users try to open a new form; they receive the following error and are unable to open the form.

Form template: _http://server/sites/subsite/library/forms/template.xsn
InfoPath cannot open the following view: Edit_View
The following view file is not valid: view1.xsl
The file is not a valid XML document.

An invalid character was found in text content.

Line 673, Position 12

I am not sure what is wrong here (or) from where this error is being generated!

Balaji Baskar [Please mark the post as answer if it answers your question]
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend