I have two tables Table 1 has 3 fields (emp_ID,Emp_Name, Emp_Address) Table 2 has several fields, out of which first four fields are (GroupNum, Empname, Serial_Num , DOJ). I need a VBA code that will move the value of Second column from Table 1 automatically to second table's second field.
On basis of this in existing table 2, first two fields gets autopopulated. Like say now we have 20 employees record in Table 1 then all the employees records get automatically transfered to table 2. Basis this all these 20 record get the same group number like "Grp001", Serial number starts from 1 for first record to 20th record.
Now let say after some time user gets 30 more records in table 1 now before moving these 30 records into table 2 . It will automatically check for group number, last time grp number was "GRP001" now for these 30 records it shud be "GRP002" and at the same time it check for the value of serial number in table 2 and again for these records it starts the value fo serial number from 1.
I need a VBA code name of first table is "Employee" and the second table is "Employee Group". Name of database is Emp_Mangmnt.mdb"
Any help is appreciated.
Regards,
Shane