.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

Add new record to a sql table that has a foreign key relationship using infopath form

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


it's me again.

i want to know how can i add new records to a sql database table that has a foreign key relationship with another table using infopath form.

i have created a blank form based on database

i have all my fields and the "add new" button already in the form.

i have the username and the userid filled in automatically when the user opens the form.

when i fill in the form with new data and click submit. it gives me this error:

Field or group: BE_CODE
Error: Only integers allowed

this "BE_CODE" field has to be filled in the database table, it can not be null. but it must not be filled in by the user it self. and it is a repeating table so it can not be auto increment.

how can this field also be filled in the database table?

View Complete Post

More Related Resource Links

Infopath form using Visual Studio - How to bind repeating table on submit button click ?


Hello friends,

   I have created infopath form using Visual Studio 2008

Form have 3 dropdowns and one repeating table which is bound by Datasource ( List from sharepoint ).

whenever i select appropritae values from drop down, Repeating table gets bound as datasource for dropdown and repeating table are same.

I have done conditional formating for repeating table using repeating table properties.


My Question:


Now i included one submit button and i want when i click submit button it will check DropDown Values and if appropriate record matching these values found it will fill repeating table

How i achive this ? as i dont find how to bind repeating table on submit button.

Please help if anyone have answer.


Thanks and Regards,


Kapil Bhosale.




How to identify new row in repeating table and repeating section of browser enable infopath form

Hello All,   I have Exp form that contain repeating table as well as repeating section. When i click insert new item it inset new row but i didn't got identification of that row. Is there is way to get identification of each row in repeating table as well as section.  Please help on this.  Thank you.

Using InfoPath Repeating Table in Task Edit form

I need to develop an InfoPath Task Edit form. The form will be used for the approval of the expense reports. I want the users to see the content of the expense report directly on the InfoPath form without clicking on the link and viewing it in a separate window.

I wonder if I can stick the expense report data which is a list into the extended properties of the task and then bind it to InfoPath Repeating Table?



Infopath 2007 Form with the repeating / non repeating fields in the same table



Hi ,

I am trying to create infopath 2007 form with the repeating / non repeating fields with in the same table. Basically i have to get the few column values  from the sharepoint List and remaining will be free text.


A     B   C     D      E    F  

x    x    x     e        a    y

x    x    x    s      s     g

x    x    x    h       t    w

x    x    x    j       h    t


X - Values getting from the sharepoint list by using repeating table

remaing values should be not repeating fields and  should be text fields.

anyideas on this. please let me know.



Infopath Browser Enabled Form - Filters dont work inside repeating table



I have been trying to create a Browser Enabled form to be used as a Sales Order form, the form will work in the following way.

It will pull in info from a sharepoint list with Customer Codes, it will pull in info from another sharepoint list with customer contact information which will be filtered based on which customer is selected.

There will then be a repeating table to place the order items.  The repeating table has 8 columns, 6 of which are lookups against 1 sharepoint list (all the columns are in the same list).

The sharepoint lsit data looks something similar to this:

Item Type                 Item Provider                    Product Relation              Product Description                Delivery Team              Cost
Service                     Us                &

How to calculate workdays in a repeating table on an infopath form


hope someone can help me with this...

i'm using infopath 2007. i have created a repeating table connected to a sql server table.

the table consist of 2 date picker and a textfield.

does any one knows how i can calculate work days. (no weekends day) in this repeating table?

i have take a look at the solution of

http://alecpojidaev.wordpress.com/ . but it is not working for me.  i have a repeating table with 2 datepicker, and he is using only 1 datepicker

Getting all data from a repeater table in Infopath Form to the List Published.


I have a infopath form and inside it there is a Repeater Table.

When i publish then it asks for the First Row of the repeated table only. Is there a way we can have all the Row Datas availabe to the list.

I want my users to get that all data in the list not by opening the Form. But the List shows data from the First Row Only.

I am trying to send those data through a workflow in SPD.

Thanks in Advance for any kind of solution.


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

Command Management: Use Design Patterns to Simplify the Relationship Between Menus and Form Elements


In Windows Forms applications, similar commands, such as those in a menu and their counterparts on a toolbar, are not automatically related. They don't fire the same event or run the same handler routine. Yet code that allows the same or similar user commands to fire the same code simplifies development.This article describes the principles of command management and why it's important to have functional commands that are not exclusive to any one UI element. In order to provide an MFC-like command management infrastructure, a design pattern is developed and applied as a series of C# classes.

Michael Foster and Gilberto Araya

MSDN Magazine October 2002

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?


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

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]

infopath form stuck with installing or deleting



I am deploying an infopath form in central admin and it stuck with the message "installing" and if i try to remove it stuck with message 'deleting". I restarted timer as well admin jobs in all servers (front end and app) but it is still showing the same. I also renamed my form and tried..no result. Can any one suggest me how to resolve this? I am wondering how it s happening just from one week.there are no changes in servers as well in environment. It works well before.



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