history
Egyptian Pharaoh
- Local time
- , 01:58
- Joined
- Jan 26, 2008
- Messages
- 190
Dear Friends,
I have 3 tables :
1-Emp
ID_Emp (Primary Key)
Sites_Comp
2-Dep
RefNo (Primary Key)
ToSite
3-EmpDep
ID_Emp
RefNo
I have a form contains Dep and sub form of EmpDep
This Form should contain RefNo and ToSite (Dep)
related to them numbers of employees listed in the subform (EmpDep)
After the form will be filled I want the field of (Sites_Comp) in Table Emp will be filled with data in the field of (ToSite) for each employee
How Can I update the (Emp Table) from (Dep Table)for each employee in (EmpDep) .
Thanks in advance,
waiting your reply
I have 3 tables :
1-Emp
ID_Emp (Primary Key)
Sites_Comp
2-Dep
RefNo (Primary Key)
ToSite
3-EmpDep
ID_Emp
RefNo
I have a form contains Dep and sub form of EmpDep
This Form should contain RefNo and ToSite (Dep)
related to them numbers of employees listed in the subform (EmpDep)
After the form will be filled I want the field of (Sites_Comp) in Table Emp will be filled with data in the field of (ToSite) for each employee
How Can I update the (Emp Table) from (Dep Table)for each employee in (EmpDep) .
Thanks in advance,
waiting your reply