Employees Transfer Record History (1 Viewer)

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.
 

Attachments

  • Capture1.png
    Capture1.png
    210.1 KB · Views: 137

theDBguy

I’m here to help
Staff member
Local time
Today, 02:02
Joined
Oct 29, 2018
Messages
21,358
I would place the company assignment in a child table and use a subform for it.
 

Users who are viewing this thread

Top Bottom