Automating a sales form

[Shemp]

Here's how to set it up:
1 - Create a database in Access with just three fields: Part No.,
Description, and UnitPrice. Give it some values, so it looks like
this:
PartNo Description UnitPrice
1001 WidgetA 100
1002 WidgetB 200
1003 WidgetC 300
Save it and export to XML.

2 - Create a blank new form with a Repeating Table containing 3
columns. Name the three textboxes txtPartNo, ddnDescription, and
txtUnitPrice, respectively.

3 - Change the middle textbox to a dropdown, and point its data source
to the XML table you created in 1.

So far, so good. What I want to do is be able to change the
description in ddnDescription and have txtPartNo and txtUnitPrice
change along with it. I can get the UnitPrice to work but not the
PartNo as well. Can anyone help?

If you want to see more of what I am doing, add a Quantity column and
an Extended Price column as well. The math is fairly easy on that, but
making the other three field ssynch up is confusing to me. Thanks!

 

[Patrick Halstead [InfoPath MVP]]

Hi Shemp,

Are you using a rule and filter to set the value for the txtUnitPrice? Seems
to me like that kind of a thing would suffice for the txtPartNo as well,
but depends on the DB binding I suppose. I guess I need more info. Can you
send a sample of your solution out?

Cheers

 

[Shemp]

Any thoughts on this, anyone? Has anyone actually done this? Is this
perhaps in a sample form tha tI could copy? I need to finish this form
by EOW.

Thanks!