Associate Values with Drop Down Items

B

bzbjg

I have a drop down list and want those items in the drop down to be
associated with certain values. How can I achieve this? For example: drop
down = walk to store - time value would be 1.5 hours.
 
B

bzbjg

No. All I've done so far is create a combo box, and in the Row Source I
listed my drop-down items. If I create a table and list the items under the
Field Name, what is the related Data Type, in order to make this have a time
value?
 
D

Duane Hookom

Your requirement sounds like a simple lookup table with a value/field that
you want to store and then a field to store a related value.
 
Top