make table question

[Guest]

I have 3 tables that are ODBC connections to our database. Two of these
tables have invoice number as a field. In one table, invoice number is
numeric; in the other, it is alphanumeric. I did a 'make table' query on the
alphanumeric table and created a new 'invoice' field that is numeric. Then I
used the new table in a query to tie all 3 tables together. I see that tables
made this way do not update automatically, which is a problem. Any other
suggestions for doing what I need to do? I'm not a programmer, and I don't
know sql. Thanks for any help offered.

 

[[MVP] S.Clark]

I can't say that I know exactly what you need to do.

I also don't know why you did a make table query to create a single column.

 

[John Vinson]

I have 3 tables that are ODBC connections to our database. Two of these
tables have invoice number as a field. In one table, invoice number is
numeric; in the other, it is alphanumeric. I did a 'make table' query on the
alphanumeric table and created a new 'invoice' field that is numeric. Then I
used the new table in a query to tie all 3 tables together. I see that tables
made this way do not update automatically, which is a problem. Any other
suggestions for doing what I need to do? I'm not a programmer, and I don't
know sql. Thanks for any help offered.

Well, a make-table query does just that - it takes the data that you
provide, and makes a new table. That new table will thereafter have no
connection to the other tables; it's a *NEW TABLE*, free and
independent.

If you want to see the data in the linked tables, use the linked
tables. You may need to join on a calculated field, which will make
the joined queries non-updateable; but if the source tables have
incompatible fields, you're stuck.

John W. Vinson[MVP]