multiple drop down list from a single Table and single value list that auto fill other fields
i have a table which has a total of 10 fields. 5 fields (dropdown) asset1; asset2, asset3, asset4, asset5, which has the same value list and 5 other fields (edit box) marketvalue1, marketvalue2, marketvalue3, marketvalue4, marketvalue5.
i want that when i choose from the dropdown/asset fields it corresponding value will appear in the marketvalue fields.
marketvalue1 = correspodns to the assigned market value of the choice made in asset1 and so on...
thanks in advance