Yes for the same employee but the employee record is divided in different tables. For example Employee Personal Information is in one table, Company data is in another table, Salary Information in another table etc
What would be your suggestion in case of different tables like scenario...
Thanx Paul;
Actually the employee is transfer from one site to another. Each site has its own staffNo like AKA-111 employee is at site 10 while the same employee transfer to site 14 with new staff No ALM-123, when employee transfer. The employee remaining data needs to be updated against staff...
I have the employee data record... I want copy of the same record to insert in table but with different employee id and Site through forms. StaffNo is the primary key.
For example
existing record
StaffNo, Site, Name, hiring date, etc
AKA-111, 10, John, 25-10-13
new record
StaffNo, Site...
I am facing one problem and needs our guidance.
My scenario is as follow:
I have employee attendance in Excel i.e Emplpyee Number, Day1, Day2, Day3....Day31
I have a table in access that have columns Employee Number, Day1, Day2, Day3...Day31, Presents, Annual Leaves etc
Excel file data needs to...
Hello! Very happy to find this community
My name is Muaz Qazi and I live in Abuja, Nigeria and I belong to Pakistan.
I am in the field of IT since 1997. I worked on IBM AS/400, IBM System/36, RPG and COBOL. I also become a SAP Development Consultant in NetWeaver-ABAP in February, 2007.
My...