Newbie Questions

Re: How to use the value of one field in mutiple record when updating database

Hilary Stoupa — Thu, 15 Jan 2009 00:44:24 GMT

And what I am suggesting is that you click on the EmpName field in your data source task pane (where you clicked on the group for the repeating table) and set the default value to equal the data node that the drop down you created is bound to. That way, when they select the value from the drop down, all the rows in the repeating table get set to that. I'm including a simple sample form with this post -- just right click the link in the header to the post, select 'Save Target As' and save the file locally. Open in design mode and preview the form to see how it works....

Re: How to use the value of one field in mutiple record when updating database

Ychhoker — Thu, 15 Jan 2009 00:26:59 GMT

Hi Hilary,

Thanks a lot for the reply. Assume i have a simle Table in database emptable with "EmpName", "TaskName" and "Hours" Column. When i design a form i add a drop down list and enter values manually into this drop down list ( e.g. "John", "Mark" etc). Then i select datasource, right click and select repeating table. This repeating table have all the three columns, "EmpName", "TaskName", "Hours". Now i delete EmpName column from the repeating table to avoid duplication of information.

So when user opens this form, he/she can select his/her name from the drop downlist and then enter values in TaskName and Hours. Then click on Insert item and add one more row to repeating table. Again enter value for TaskName and Hours. Now there are two rows in repeating table. If user hit submit button the values that goes to table is

EmpName, TaskName, Hours for the first row but for second row only TaskName and Hours. So what i want to achieve is that whatever value is selected in EmpName dropdown list that value should get inserted to database for each row on submit.

Thanks a lot for for your patience to read it all through :)

Re: How to use the value of one field in mutiple record when updating database

Hilary Stoupa — Wed, 14 Jan 2009 21:28:15 GMT

In your data source task pane for the form, I'd guess that the employee name field is in the top group and also repeated in the group which your repeating table is based off of -- is that correct? If so, you could set the default value for that 'child' EmpName field to be the same as the higher level field that your EmpName drop down is bound to.... does that make sense?

Re: How to use the value of one field in mutiple record when updating database

Ychhoker — Wed, 14 Jan 2009 21:18:21 GMT

Hi Frederik,

Thanks a lot for replying. But i want to save this data into database. What i want is user opens this form. Select his/her name from EmpName drop down list.

And in the repeating table add a row, fill Task and Hours. Insert one more row and fill Task and Hours and then hit submit button.

EmpName	John

Task	Hours
Team Meeting	2
Bug Fixing	6

Now when submit button is hit, the data that goes to database is

Empname Task Hrs

John TeamMeeting 2

Bug Fixing 6

-----------------------------------------------------------------

But what i want is

Empname Task Hrs

John TeamMeeting 2

John Bug Fixing 6

I hope you can understand my problem.

Re: How to use the value of one field in mutiple record when updating database

Frederik Van Lierde — Wed, 14 Jan 2009 10:45:45 GMT

First Submit Button is not the way to go, as Submit is used to submit the data to a dataconnection, like webservice, sharepoint, xml file

When exactly do you want to reach, when the user selects an item from the dropdown, it shows the information, do you want the user to update/change the information, or is it just for showing ?

If you give me more info I can bring you into the right direction.

One hint already is to use filters when the value of the dropdown is changed.

How to use the value of one field in mutiple record when updating database

Ychhoker — Tue, 13 Jan 2009 21:41:29 GMT

Hi,

I am using Infopath2003 still taking baby steps to get familiar with Infopath and i have mixed success.

DataSource Details: SQL Server

Table1 have empid and empname

Table2 have empname, task, hours. These two tables have relationshiop on empname column.

The issue that i am facing is that i want to create a time card form which look like this.

Employee name as drop down list. This field is populated from SQL Server database.

A repeating table having "task" and "hours" column.

So whenever a user open this form, he/she can select his/her name and then add rows to repeating table. And then click on submit button.

Now when user hit submit button what i want is that Table2 should get populated with "empname, task, hours" for each record. But this is not happening.

empname is getting inserted for first record only. Other records have empname as blank. How can i make infopath to insert records with empname for every row in this form.

Thanks a lot in advance :)