Two data items from a populated dropdown menu
DreamweaverMX v6.1, Access2002
On a form, I am populating a dropdown menu from a datafile. The datafile contains 2 text fields
'Position' and 'PositionCode'.
I would like to know how to get values from both fields when a user make a selection from the dropdown menu.
When the user selects a 'Position' from the dropdown, I want to input it and the PositionCode into a third table.
The best I've gotten so far is both fields together and entered into the third table. e.g. Instructor Pilot,55
Before I go down the road of trying to split the field into two separate items I'd like to know if there is a simpler
way to do this. It seems like a common thing to do but after asking on four forums I still don't have a solution.
Any Ideas Would Be Appreciated