Lookup Field
Check the combo box property
In row source give query lik
select customer_name, customer_id from customer table
in property bound column give 2
now in form it will show the customer name but store value customer_id in the table when you save .
If i mis-understand accept my...