Need Help in access

[vaidehikumar]

I have a drop down list in a table with name and commission rate. When I choose the name it displays but I want both the name and the commission rate to display in my table. I want to use a data entry form to enter values in the table and I want the same in the form too (when I choose a name I want the corresponding commission rate to show up). Thank you for your help.

 

[jdraw]

see http://access.mvps.org/access/lookupfields.htm