Hello,
Trying to set up a combo box on a main form to allow me to update a field in a table OTHER than the record source of the form. I have the following set up...
MainTable
MainTable2
AppType
MainTable and MainTable2 are linked one-to-one by EvID (number). They function essentially as two master tables, as the original MainTable reached the limit of relationships available to other tables. MainTable2 is basically overflow from MainTable.
My form is built on MainTable. I need a combo box to look up values in the table AppType (contains fields AppTypeID and AppTypeDescription), show AppTypeDescription in the combo box on the MainTable form, and update a field in MainTable2. The field in MainTable2 should store the number AppTypeID.
Any help would be greatly appreciated!