i'm a scripting newbie, so i'm unsure of how to do the following:
i have a value list in drop-down menu format that users will have to choose a particular item.
for example, if my value list is "A, B, C, D".
and the corresponding prices for each of those items are "$2.00, $5.00, $8.00, $10.00".
what script can i use that will automatically show the price of the item (in the layout) depending on the user's selection from the value list?
for example, if the user selects "D", then the corresponding price of $10.00 would show up.
do i have to setup two value lists (items and item prices)?
once i know which script to use, how would i insert this script so the database would use it?
using FM12.v5, OSx 10.9.5.