using secondary data to look up information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard MG - 24 May 2006 09:11 GMT

I am new to InfoPath, have a little Access knowledge and can programme Excel
with VBA.
I am trying to create an order form with fields in the Main data source
refering to a secondary data source brought in from Access. This latter is a
simple table with Index, Item and Price. I have successfully added the
secondary data source and created a Dropdown List from it in a "Materials
Item" field in a repeating table.
I have tried using an Expression box bound to the Price to bring the price
in but I am told that the secondary data source is not repeating so it calls
the first item in the price list. How do I get it to find the correct price
for the Material Item chosen?

Reply to this Message

S.Y.M. Wong-A-Ton - 13 Jun 2006 21:51 GMT

Add a normal text box to your form. Then add a rule to the drop-down list box
that sets the value of the text box to the price that can be found in the
secondary data source. When adding the rule, use the secondary data source to
select the price field and add a filter ("Filter Data..." button on dialog
box) that will compare the value of the item field in the secondary data
source to the selected value in the drop-down list box, which is actually a
field in the main data source.
---
S.Y.M. Wong-A-Ton

> I am new to InfoPath, have a little Access knowledge and can programme Excel
> with VBA.
[quoted text clipped - 7 lines]
> the first item in the price list. How do I get it to find the correct price
> for the Material Item chosen?

Reply to this Message