How to use a table to populate same fields of a second table

Discussion created by mbeck65 on Aug 29, 2014
Latest reply on Sep 5, 2014 by mbeck65


I'm a newby and apologize for the proposed problem that, mayby, could be easy to be solved... But I'm not able to do it, at the moment...

The context is the following: I imported a table (we call it TABLE A) from another DBMS and now I would like to use the data inside this table only as a "facility" to populate my main table (TABLE B)...

I mean: how could I perform a serch inside TABLE A (possibly without declare relationship) in order to select 1 record and copy to the TABLE B some fields of the record selected?


Thanks a lot for your support.