I have a form that has three tables. The main table is an ODBC connected
table, then a second ODBC table with the third slave table local to the database. I.E. ODBC Table A | ODBC Table B | Local Table C All three tables have only one common column "SerialNo" of the same data type. When I edit data with the form, tables A & B populate, but C does not. If I project temporary local tables from A & B and use them in the form instead of the ODBC versions, all three tables populate when using the form. At first look, it seems that a form does not like to mix ODBC tables with local tables. Can any one please confirm this or offer input. (Using the projected local tables is not an option for the application. I have confirmed that all three tables have a common column of the same name and data type) Thanks, -Bob
