InfoPath Dev

 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

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?

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!

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.

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  

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.