Re: How to auto-fill text box from SQL db query

markf — Fri, 15 Jun 2007 21:48:16 GMT

I am wondering now if I went about this the wrong way. Is there another way to bring the results of a SQL query into a form and then to allow a user to edit those results before submitting the form?

Thanks for any help!
Mark

How to auto-fill text box from SQL db query

markf — Fri, 15 Jun 2007 21:04:09 GMT

Hello,

New to InfoPath and I am stumped. I am trying to auto-fill a text box

control with SQL data that would be dependent on two drop-downs and enable a

user to edit the contents of the text box before submitting the form.

I can pull the data from the SQL db for the two drop-down boxes and can get

the first value (Ex. ‘Computer1’) to populate the text box but that is all

that I can get. How can I populate with the remaining computer names in the

text box based on the input from the two drop-downs?

Thanks!

Mark

1) Query #1 = data for drop-down box #1

2) Query #2 = data for drop-down box #2

3) Query #3 = data for text box where user can edit server list (Ex.)

‘ComputerName’ field is the only thing I want to populate the text box with

and I use InfoPath data filters to filter on the two drop-downs.

Ex.

Computer1 -> auto-filled

Computer2 -> auto-filled

Computer3 -> auto-filled; user deletes this line

Computer4 -> auto-filled

Computer5 -> user adds this line

Query #1

SELECT ApplicationVersionID, ApplicationName, Applicationstatus

FROM Applications AS Applications

ORDER BY ApplicationName

Query #2

SELECT EnvironmentID, EnvironmentName

FROM Environments AS Environments

ORDER BY EnvironmentName

Query #3

SELECT svr.ComputerName, ap.ApplicationName, env.EnvironmentName

FROM Servers AS svr INNER JOIN

Allocations AS alloc ON svr.AssetNumber =

alloc.AssetNumber INNER JOIN

Assignments AS asn ON alloc.AssetNumber =

asn.AssetNumber INNER JOIN

Applications AS ap ON asn.ApplicationID =

ap.ApplicationVersionID INNER JOIN

Environments AS env ON alloc.EnvironmentID =

env.EnvironmentID

Newbie Questions

Re: How to auto-fill text box from SQL db query

How to auto-fill text box from SQL db query