I have a form with multiple tabbed pages that draws information from 2 tables. I have a combo box that assigns a value to the ORIGINATOR field. When I pick the ORIGINATOR from the combo box, I want it to automatically update the values of two other controls on the form, REGION and OFFICE, and store these values in a table. There are two tables involved in this:
1. CCBPIPE is where I want to store all of this information
2. Branch_Table has only ORIGINATOR, REGION, and OFFICE as fields, so it should be used for looking up the REGION and OFFICE based on the ORIGINATOR that is chosen.