form to populate orders list sourcing customer list

May 19 2010 4:09 PM

 
i have two lists: Customers and Orders
 
i want to create a form that populates Orders list but sources the Customers list to get Customer_ID
 
The catch is that i want the user to choose from a list of customer names and have but to have the form return customer_id
 
an example of this is html drop-down boxes. they can be created to show one value (eg customer name) but return another value (eg customer_id)
 
im certain there must be a way to do this in sharepoint but have found no reference to it.
 
-Dave

Answers (3)