I have a look up field to a table that stores the agent name and commission rate.  On returning the agent name from a drop down list id like to place the commission percentage into another field can someone point me to an example.

Thanks.