Data Connections

Re: Struggling with many-to-many relationship

Hilary Stoupa — Wed, 26 Sep 2012 22:16:35 GMT

Can you use SQL Express or SQL on a server? I guess you could use two SharePoint lists - one would be your apps list, the other your servers list with a lookup column to your apps list that allows multiple values.

Re: Struggling with many-to-many relationship

adrianodl — Wed, 26 Sep 2012 06:28:38 GMT

Hi Hilary,

I spent quite a lot of time working on it and finally got it working, but as usual, you just stumble on a different rock. :)

I got the interaction between Infopath and access working beautifully, but since the DB was hosted on my pc, Sharepoint users got a security alert.

What's the best way to upload this DB to sharepoint? I tried uploading it as a document but the form wasn't able to use it as a souce of info. I also tried to export it as Sharepoint lists, but since there is no relationship between the lists I'm not sure how to proceed.

thanks for your help,

Adriano

Re: Struggling with many-to-many relationship

Hilary Stoupa — Tue, 25 Sep 2012 15:15:16 GMT

So, it actually doesn't sound like many to many in your description - one server may have many apps. The apps may appear on more than one server.

To me, it seems like your form would be based off the server table, and your apps table would simply be a secondary data source.

Re: Struggling with many-to-many relationship

adrianodl — Tue, 25 Sep 2012 00:23:30 GMT

Hi Hillary and thanks for your reply!

Just to give you a bit of context, what I'm trying to achieve is a Request for Change form (RFC) that once the user selects a server, it displays all the applications hosted in it.(I'm planning to use a multiple selection field for servers, and a repeating table for the apps).

What you said kind of made sense, but I'm not sure how to build it in Infopath. I can send you a sample of the DB if it helps!

Re: Struggling with many-to-many relationship

Hilary Stoupa — Tue, 25 Sep 2012 00:17:12 GMT

Do you need to be able to create Apps without Servers? That is, would you need your form to submit to the Apps table but not the Servers table?

If so, I'm wondering if you could create a kind of parent dummy table - with perhaps just one field / row with an ID in it - and then you could relate your Apps table to that, as well as your Servers table.... does that make sense?

Struggling with many-to-many relationship

adrianodl — Tue, 25 Sep 2012 00:09:53 GMT

Hi there,

I have a form that should display information retrieved from an access DB with the following structure:

Server Application

Server1 App1, App2

Server2 App2

Server3 App1

As you can see, one server can host multiple Apps, and an App can be hosted in multiple servers.

How do I build this relationship in an Infopath form?

The Access DB is built as follows:

TableServer TableRelation TableApp

IDServer IDServer IDApp

ServerName IDApp AppName

Hope it's clear enough, but if not, just let me know!

Thanks in advance!

Adri