smtazulislam
Member
- Local time
- Today, 12:02
- Joined
- Mar 27, 2020
- Messages
- 806
Ramadhan Kareem,
I having a database where have many branches and always transfer the employee. I needs to a TABLE and FORM how to record their transfer history.
Example TABLE : EmployeeID - TransferDate - CompanyName- BranchType - DepartmentName - DepartmentType - Status
this record is present employees.
THEN, I want to record also PRESENTCOMPANY to transfer NEWCOMPANY record. [Noted: Don't want to replace any data]
Example DATA : EmployeeID - PRESENTCOMPANY_TransferDate - PRESENTCOMPANY_CompanyName- PRESENTCOMPANY_BranchType - PRESENTCOMPANY_DepartmentName - PRESENTCOMPANY_DepartmentType - LeaveDate - NEWCOMPANY_CompanyName- NEWCOMPANY_BranchType -NEWCOMPANY_DepartmentName - NEWCOMPANY_DepartmentType - Remarks.
SL - EmployeeID - TransferDate - CompanyName- BranchType - DepartmentName - DepartmentType - Status
1 - 100 - 01/05/2020 - ABC - Y - HR - ADMIN - N/A
2 - 100 - 06/05/2020 - DEA - Z - HRC - ADs - N/A
also needs to show in the FORM last record (SL - 2)
Also needs to show in the FORM employee how many branches he visited.
I having a database where have many branches and always transfer the employee. I needs to a TABLE and FORM how to record their transfer history.
Example TABLE : EmployeeID - TransferDate - CompanyName- BranchType - DepartmentName - DepartmentType - Status
this record is present employees.
THEN, I want to record also PRESENTCOMPANY to transfer NEWCOMPANY record. [Noted: Don't want to replace any data]
Example DATA : EmployeeID - PRESENTCOMPANY_TransferDate - PRESENTCOMPANY_CompanyName- PRESENTCOMPANY_BranchType - PRESENTCOMPANY_DepartmentName - PRESENTCOMPANY_DepartmentType - LeaveDate - NEWCOMPANY_CompanyName- NEWCOMPANY_BranchType -NEWCOMPANY_DepartmentName - NEWCOMPANY_DepartmentType - Remarks.
SL - EmployeeID - TransferDate - CompanyName- BranchType - DepartmentName - DepartmentType - Status
1 - 100 - 01/05/2020 - ABC - Y - HR - ADMIN - N/A
2 - 100 - 06/05/2020 - DEA - Z - HRC - ADs - N/A
also needs to show in the FORM last record (SL - 2)
Also needs to show in the FORM employee how many branches he visited.