autopopulating a field based on another field

[Jeffrey]

Forgive me as I'm incredibly new to InfoPath, have minimal programming
experience, and need some direction:

I am creating a new-user form for my IS department. We have a SharePoint
list that contains all the software we order and how much it costs.

My InfoPath form has a field, software_product, that references the list to
pull all available software packages into a drop-down menu. There is a field
next to it called software_price. I would like software_price to populated
from the smae SP list, based on the user selection in software_product.

For example, if a user selects Office 2003 in software_product, I want the
software_price field to automatically display $599, the listed price the SP
List.

Any help or suggestions would be appreciated.

J

 

[Franck Dauché]

Hi Jeffrey,

You need to use Cascading Drop-Downs.
Check this link: http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx

Hope that it helps.

Regards,

Franck Dauché

 

[Jeffrey]

Frank,

Thanks for the super-fast reply. From a link off this page, I completely
understand how to do this with cascading dropdowns. Based on the directions,
I used filtering to accomplish this.

That said, I'm still getgin errors when I try it for my text field. I've
tried:
@Price [@Product = current() software_product)
and
@Price [@Product = software_product)

Any suggestions? In the interest of full disclosure, I have no real
infopath/dev experience so I'm not sure if I'm readin paths like
/Root/Data/Cities/City[ @state = /Root/Selection/SelectedState ] correctly.

Thanks

 

[Franck Dauché]

Hi Jeffrey,

Look at the thread from today untitled: Filtering Secondary Datasource (8
posts below yours). It may help.

Regards,

Franck

Frank,

Thanks for the super-fast reply. From a link off this page, I completely
understand how to do this with cascading dropdowns. Based on the directions,
I used filtering to accomplish this.

That said, I'm still getgin errors when I try it for my text field. I've
tried:
@Price [@Product = current() software_product)
and
@Price [@Product = software_product)

Any suggestions? In the interest of full disclosure, I have no real
infopath/dev experience so I'm not sure if I'm readin paths like
/Root/Data/Cities/City[ @state = /Root/Selection/SelectedState ] correctly.

Thanks

Hi Jeffrey,

You need to use Cascading Drop-Downs.
Check this link: http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx

Hope that it helps.

Regards,

Franck Dauché