Repeating table/query fields question

[crashoverride]

I am having a problem because Infopath will not allow me to bind a repeating
table to query fields.

What I need to do is be able to edit and submit several rows of records in
an Access database at one time from my infopath form.

 

[Andrew Watt [MVP - InfoPath]]

I am having a problem because Infopath will not allow me to bind a repeating
table to query fields.

What I need to do is be able to edit and submit several rows of records in
an Access database at one time from my infopath form.

Can you explain more precisely the business task you are trying to
accomplish?

Andrew Watt
MVP - InfoPath

 

[crashoverride]

A table in my access database contains information regarding returns on
several investments in various months. Each row of data contains information
about the return month, return year, return %, balance of money invested, and
the name of a portfolio an investment belongs to.

I have already created and implemented a form which creates new records for
any number of investments in a particular portfolio for a given month and
year. (In other words, a user is able to submit more than just one record to
the database at one time) I used a repeating table to accomplish the task.

However, I need to accomplish a similar task of allowing a user to enter the
balance of money invested for several investments at once. I must implement
it in a different form because of the timing differences in reporting the
return % and the balance of money figure. Thus instead of merely creating
multilpe records in the table like my first form, this form must be able to
query (find the records that have already been created) and then edit the
balance of money field and then submit the records back once again to the
database. Due to the nature of the seperation between query field sections
and data field sections I have not been able to figure out how to use a
repeating table to accomplish the goal of querying several fields at once and
then submitting several fields at once. Any help would be greatly
appreciated!!!!

 

[Mauryaguru]

Hello
I think I have a problem similar to crashoverride. My objective is to edit
and submit, or delete, from my InfoPath form, a single row in a secondary
data source (a SharePoint list). Here is the exact scenario:

As soon as my InfoPath form from my primary data source (a SharePoint
Document Library [I think this is essentially a SP list] called "Issues")
opens, I sucessfully query from a secondary data source (a SharePoint
Document Library called "Action Items" [there are many Action Items for one
Issue]) all the many Action Items related to my one Issue, and populate my
InfoPath form for my Issue with those Action Items (I use a Repeating Section
to allow for many Action Items).

HOWEVER, I am unable to edit and then SUBMIT an edited Action Item queried
above, to the original secondary data source (Action Items Library in
SharePoint). I
am also unable to DELETE from my InfoPath form, any Action Item queried
above, from the original secondary data source.

I am on a time crunch, and any help with this problem would be greatly
appreciated.

Thanks,
Mauryaguru

 

[Mauryaguru]

Thanks for the reply Greg

They are in a SP list so that the Action Items can be accessible outside of
any Issue Form. That way, you can access and edit an Action Item directly
(from the Action items SP list). If the Action Item is in the Issue form's
XML, in order to access an Action Item, you would first have to go to the
parent Issue's Form.

If the Action Items are in their own SharePoint list spanning various parent
Issues, then we can use the filter feature of SP lists to filter out Action
Items that we are interested in.

Thanks

Mauryaguru

Why are your action items in a SP list rather than part of the XML of your form?

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Hello
I think I have a problem similar to crashoverride. My objective is to edit
and submit, or delete, from my InfoPath form, a single row in a secondary
data source (a SharePoint list). Here is the exact scenario:

As soon as my InfoPath form from my primary data source (a SharePoint
Document Library [I think this is essentially a SP list] called "Issues")
opens, I sucessfully query from a secondary data source (a SharePoint
Document Library called "Action Items" [there are many Action Items for one
Issue]) all the many Action Items related to my one Issue, and populate my
InfoPath form for my Issue with those Action Items (I use a Repeating Section
to allow for many Action Items).

HOWEVER, I am unable to edit and then SUBMIT an edited Action Item queried
above, to the original secondary data source (Action Items Library in
SharePoint). I
am also unable to DELETE from my InfoPath form, any Action Item queried
above, from the original secondary data source.

I am on a time crunch, and any help with this problem would be greatly
appreciated.

Thanks,
Mauryaguru

I am having a problem because Infopath will not allow me to bind a repeating
table to query fields.

What I need to do is be able to edit and submit several rows of records in
an Access database at one time from my infopath form.