This topic is locked

Auto-populate fields

9/16/2005 10:19:08 AM
ASPRunnerPro General questions
Corinne author

Pretty basic. I have a combo box that the user selects from. Once they select an item I want the price that is associated with that item to auto-populate into the unit price field on the add screen. In the table that the combo is attached to I have an ID field, a item field and a price field. The combo is of course attached to the item field. How Do I make the unit price field on the add form fill with the correct value?
Thanks,

Corinne

Corinne author 9/19/2005

Anyone????? Sergey??? Can this be done??

admin 9/20/2005

Corinne,
you can use dependent dropdown boxes, where values shown in the second dropdown box depend on the value you've chosen in the first one.
Set Edit as - Lookup wizard format for Pricefiled and make it dependent on the Itemfield.

If you have problems with Lookup wizard setting please post here your database structure. I'll help you.