Need more then 2 field in drop down list can it be done
can you have more information in a drop down list then 2 fields
Information, yes. Fields, no.
You can have a calculation field that assembles your info by calculation and show all your info on one field for your dropdown.
Calc= Field1 & " " & Field2 & " " & Field3.....
Retrieving data ...