transfering records from table to table with where

[Nickman]

hi

I have two tables (TCustomer & TPolice), they are joined by field (partner_nr)

I want to get all information out of TCustomer.User_nr and put it into TPolice.FKB_VST_NR where TCustomer.Partner_nr = TPolice.Partner.nr

I would prefer doing this without creating a new table.

thx in advance
Nick

 

[mymou]

Hi Nickman


Have you looked into append queries?


Stew "Even a stopped clock tells the right time twice a day."