Hello,
I have a table, table1, and created a detail table of table1, I want to move the value of a field of the master table to the detail table without do it manually (about 700 records), is there any way through sql or vb .net?
master table id (PK), name, carnum, address, ssn, ead, sub (integer want to move value to detail field for each master record)
detail table id (PK), id_2 (FK), year, sub (in this field I want to move the value of sub for each master record), receip_num