S
sanand
Hi experts,
I have a form based on table1. By selecting the ProjNum from a combo box on
this form, I need to add the selected ProjNum to another table (Table2).
Table1 is the master table with all the projects and related info. the
Supervisor wants to accomplish the following:
1. Enter the newly received project in Table1
2. By selecting this new Project from the Combo Box on the frmMaster, need
to assign to another
Tech1(uses Table2), or Tech2(uses Table3), or Tech3(uses Table4)..
3. Each Tech has its own form to view the projects assigned to him/her.
How this can be accomplished?
Any assistance is appreciated.
TIA
sanand
I have a form based on table1. By selecting the ProjNum from a combo box on
this form, I need to add the selected ProjNum to another table (Table2).
Table1 is the master table with all the projects and related info. the
Supervisor wants to accomplish the following:
1. Enter the newly received project in Table1
2. By selecting this new Project from the Combo Box on the frmMaster, need
to assign to another
Tech1(uses Table2), or Tech2(uses Table3), or Tech3(uses Table4)..
3. Each Tech has its own form to view the projects assigned to him/her.
How this can be accomplished?
Any assistance is appreciated.
TIA
sanand