InfoPath Dev

Hi all, I'm not too sure how to describe my problem, but let me give it a try: I have 3 tables (see attachment) ,and want to populate a repeating table based on my selections of TableABC. There are 3 distinct connections to my SQL database (one for each table), but I'm not sure how to correlate them. The end result should be a ...

 Hi there, Please refer to the attachment for the modelling of my DB.   What I'm trying to achieve is a form that displays the following: provide the users with a list of servers to select from (done, I'm populating a multiple-selection list box (multServers) with data fed from the DB ([Table ABC].Column Server )display ...

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? ...

 Hi there, I'm retrieving a list of servers from MS Access but they are not in any specific order. How can I sort them alphabetically?   Thanks,   Adri

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 ...

 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 ...

 Hi Gennady, That's right, the field does not support multiple parameters. I actually got it working by doing the simplest thing: field1 + field2 + field3... Easy! Thanks for your help, Adriano

Hi all, this is what I'm trying to achieve: I have a risk assessment form with determined values assigned to specific yes/no questions, with yes = 1 and no = 0. What I want to do is to sum up the values of these multiple drop down boxes and then populate a text box with the result; so for example, if 3 out of 5 answers are yes, the risk ...

Hello everyone, I'm glad I found this forum and hope I'll be able to share my knowledge as well as learning from you all. the issue I'm facing at the moment has to do with Infopath and an access database. In a nutshell, I have a DB with server names mapped to applications (this is a 1->many relationship). Wat I need ...