Data Connections, and there Relastionships will not be used when you
connnect this data connection to the controls.
On the first control you connect to the data connection as normall
The second control who wants to show data, depending on the first
control,
- go to the properties,
- select Look up values from a external datasource
- Select the data you want o show (Entries text box)
While doing this you will get a dialog box with the data sources,
also a button with Filter Data
So you need to add a filter.
Pay remark the following text when adding this filter
When using this filter you want to say the following
SELECT [SecondField] FROM [DataSource] WHERE [FK_SecondField] =
[Selected Item in First Control]
[Selected Item in First Control] will not be in the create data
source, but in the Main Source, as the data fillined by the user is
stored in the Xml behind the form (= Main Data Source)
So the filter:
Foirst dropdown: Select theField from the create datasourve
Second dropdown "Is Equal to"
Third dropdown: Selected field or group, Change the data source to
Main Data Source, select the field who is binded to the first
control;
I hope this helps
I will write a more detailed article the next week about this on my
Blog.
Also this way will not work with InfoPath Form Services, please have a
look at my whitepaper about wich features works with wich version of
InfoPath.
Frederik Van LIerde
http://www.SilverSandsAssociates.com
http://BlueInfoPath.blogspot.com