Defaulting control values based on the selection of another contro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike in Arizona - 10 Jan 2006 20:20 GMT

I am a new user/develop of Infopath and I am developing this form and I have
run into issue. I want to design a form were the value of one control is
driven by the selected value of another control. For example, if the user
selects "Product X" from a drop-down list, I want the value of the ProductID
to default to the ID associated with that Product (this is not really my
dilema, but it illustrates the point). Any ideas how I might accomplish this?

Reply to this Message

Bojana Marjanovic [MSFT] - 16 Jan 2006 20:48 GMT

There are a couple of ways of doing this, Mike.

I'm assuming you have some sort of secondary data source that has a
repeating group 'Products' with two fields under it: 'ProductName' and
'ProductID'.

You can set the default value of the ProductID field in your form to point
to the ProductID field in the secondary data source, but filtered by the
ProductName field so that it equals whatever the user chose in the
drop-down.

You can also set a rule on the drop-down to populate the ProductID field
with the appropriate value. You would still select the ProductID field from
the secondary data source and filter it with the name of the Product that
was selected in the drop-down.

Filters are key here. When you have repeating groups, you can always select
the appropriate one by filtering based on one of the fields in the repeating
group.

Let me know if this helps,
Bojana

>I am a new user/develop of Infopath and I am developing this form and I
>have
[quoted text clipped - 5 lines]
> dilema, but it illustrates the point). Any ideas how I might accomplish
> this?

Reply to this Message

Barry - 01 Feb 2006 20:40 GMT

I am doing something similar, with a twist. I would like the default value
of the control to map to a table column that allows the value to be changed
and stores any use (default or changed).
The application is an invoice page where the combobox contains product names
from the 'Products' table. Once selected, I want the unitPrice control
populated with the base price (contained inthe Products table), however, this
value may be changed by the user. In either case, a unitPrice will be saved
in the resulting 'Sales' table.

Will these approaches work in this scenario? Do you have examples that I
can reference (I'm new to Access). Thanks.
-b

> There are a couple of ways of doing this, Mike.
>
[quoted text clipped - 28 lines]
> > dilema, but it illustrates the point). Any ideas how I might accomplish
> > this?

Reply to this Message

Barry - 01 Feb 2006 20:49 GMT

Oops. I just realized, my search was not constrained to the Access group.
Sorry if this is off-topic.
-b

> I am doing something similar, with a twist. I would like the default value
> of the control to map to a table column that allows the value to be changed
[quoted text clipped - 41 lines]
> > > dilema, but it illustrates the point). Any ideas how I might accomplish
> > > this?

Reply to this Message