Multiple fields filled by Drop down List
I have a portal listing costings for various activities which users add to. At the moment one of the fields (costingType) is a drop down list with activity type eg: air travel or car travel or guest speaker. This data is prepopulated from a table called ExpenseTypes - field: ExpenseType.
In the expenseTypes table is also an ID field plus a cost field eg:
ID Expense Type Cost
1 Air Travel (Syd - Dubbo) $423.50
2. Air Travel (Syd - Bx) $395.80
In this portal is another field called Item_Cost. What I would like to do is when you select the expense type in the drop down list to fill 'costingType' it also automatically fills the Item_Cost field in the portal as well with the relevant expense. So the drop down list while attached to 1 field fills 2 fields.
Any help appreciated.
There are two basic approaches you can use. You'll need to decide whether you should copy the actual data from ExpenseTypes or just displays the current value stored in this table.
Here's a link to a thread that describes both options: Auto Fill