Hello Experts,
SQL does not copy the field (autonumber) of table1 to another field (number longue) of table2. Is this normal and is there a way around it? Here is the code:
Above table1 = TransSHTbl, table2 =TranshSHUPDTbl, Field1 = MemID, Field2=MemID
Thanks a lot.
SQL does not copy the field (autonumber) of table1 to another field (number longue) of table2. Is this normal and is there a way around it? Here is the code:
Code:
"INSERT INTO TransUPDSHTbl SELECT TranSHTbl.MemID, TransSHTbl.FirstName, " & _
" TransSHTbl.LastName, " & _
" TransSHTbl.Language, TransSHTbl.Email, TransSHTbl.Federation " & _
" FROM TransSHTbl " & _
" INNER JOIN MembersTbl ON ((TransSHTbl.LastName = MembersTbl.NOM) AND " & _
" (TransSHTbl.FirstName = MembersTbl.PRENOM)) ORDER BY MembersTbl.MemID;"
Thanks a lot.