links from queries to tables:

Hello 

Is the following possible,[1]
 (using an Odbc connection to a  mysql base.)

1. Table1 contain field1 (primary  key) field2 

2. Query1 contains
   field1, field2 and the sum of them field1+field2 with the
   alias sum12

Now I want either 

    -  to  link the whole query1 to a new table2, or

    - to link the  new  field sum12 to  a  new field in   table1,
      however that might be a little delicate infinite loops etc,
      if you are not careful.

Thanks

Uwe Brauer 

[1]  or a desirable new feature.