In a field in my form to look value from a table. What is the easiest way to make that happen?
There is another field in the form called Office which is a drop down selection. This also is the first column of the table called tblOfficePhone. After that is selected on the field I would like one of the other fields to be updated to the 3rd column of the table which is titled Manager.
What's the easiest way to make that happen?