Re: Selecting multiple rows in database query - IP2003

nukkumatti — Fri, 27 Apr 2007 11:19:12 GMT

lets assume you have two drop down lists (ddl) on your form one name field1 and one named field2 "how inventive :)"

double click your first ddl and select look up values in a dataconnection to a database.... select your secondary datasource from which you get the values of your database from the first drop down list, select the repeating node (under which your claimvalue and empids) are for the entries field and select empID as the value and display name.

for your second ddl repeat the steps described but select ClaimValue for dispaly name and value. click to the button next to the entries field and select filter data and click add. from the first drop down list of the filter select empID - "is equal to" - form the last drop down list select use formula and use this as your function current()/my:field1

If it works like expected your second ddl should now be populated only with values which fit your selection within the first ddl.

Hope this hepls.

Selecting multiple rows in database query - IP2003

markperry — Fri, 27 Apr 2007 10:43:36 GMT

I've set up a couple of actions when my form loads - the first gets some data from a sql database, the second displays the results of this data based on a filter.

I'm getting two fields back from the database - EmpID and ClaimValue. I want to show all the ClaimValues where EmpID = '000015'. So I've created an action that sets one of the fields in my form equal to the following formula:

@ClaimValue[@EmpID="000015"].

However, this only returns one value. I know that there are three values in the data table that I want to display, so how can I make InfoPath 2003 display all three values?

General

Re: Selecting multiple rows in database query - IP2003

Selecting multiple rows in database query - IP2003