SQL and repeating table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UKDeluded - 28 Jun 2005 12:05 GMT

Hi all!
Okay, I developed a quotes library to hold newspaper quotes etc relevant to
our company. They love it. Straight InfoPath XML - nothing too fancy.
To make it better though I decided to create a database behind it, re-create
the form and have it submit to the database so I can use different methods of
retrieving the information and link it through to othr systems.
The problems:
1) I have to have a repeating table for the quotes - it might be a ten page
article with quotes on pages 2 and 5 so on one row page number would be '2'
and the quote, insert new row, page 5 and so on. With the database though as
soon as you try to submit with a second row it fails. The dataset in SQL for
that part simply has unique ID, page, quote.
2) I would like the submit button to submit to the database and then upload
the form to the Sharepoint library so the visual workings remain the same. I
seem to be able to get it to do one or the other, not both.

Any clues dear friends???

Reply to this Message

Adam Harding - 29 Jun 2005 15:46 GMT

Nice idea.

To get the multiple insertions recorded in the database (on Access) the
repeating table has to be on the many side of a one-to-many relationship
between the master table and the repeating table one. Furthermore both
tables have to have an ID field to allow submission of information.

Re submitting have a look at Ned Friends article in Assistance on multiple
submissions it explains many different ways to do it.

Cheers

> Hi all!
> Okay, I developed a quotes library to hold newspaper quotes etc relevant to
[quoted text clipped - 13 lines]
>
> Any clues dear friends???

Reply to this Message

UKDeluded - 29 Jun 2005 17:31 GMT

One to many simply didn't occur to me! I'll give it a bash and see what comes
out the other end.

Thanks.

> Nice idea.
>
[quoted text clipped - 25 lines]
> >
> > Any clues dear friends???

Reply to this Message