Hello

the two tables are already in the same database. To get information from one table to another within the same database, you can use either: (select TABLE).FieldName or if the two tables are linked: TABLE.FieldName.

For example, if you want to have field 1 of your 'Oiseaux famille genres espéces' in your 'Ajout famille-tableau 2' table:

Function field in the Ajout famille-tableau 2' table:

(select 'Oiseaux famille genres espéces').'FieldName 1'  OR if the tables are linked : 'Oiseaux famille genres espéces'.'FieldName 1'

Does this answer your question? Or what data do you exactly want to import?

Here is a small example example

this will copy selected fields of data from table 1 to table 2 (Both tables must exist!)

where a condition is met ie optout = YES

for i in (select Table1)['OptOut' = "Yes"] do
let a := i.'Company Name';
let b := i.'First Name';
let c := i.'Last Name';
let d := i.Position;
let e := i.'Email Address';
let f := i.'Contact Phone';
let g := i.'Opt Out';
let h := i.'Opt Out Date';
let z := (create Table2);
z.('Company Name' := a);
z.('First Name' := b);
z.('Last Name' := c);
z.(Position := d);
z.('Email Address' := e);
z.('Contact Phone' := f);
z.('Opt Out' := g);
z.('Opt Out Date' := h)
end

Mel