I have a need to do the following:
When a user selects a lookup field (say: Service), I want to be able to automatically add the cost of the service to a field on a form. For example, if a user selects "Engine Tune Up" from a drop down list, I want it to display right beside it (for example) 135.00. When they select this choice, I need a column (field) on the form to be populated with the value of the "Tuneup". This last part I can figure out.
What I don't know how to do is to display multiple columns in a drop down like so:
"Engine Tune Up" "135.00",
"Oil, Lube, Filter" "122.00" etc...
Hope this makes sense.
Thanks.