Multiple Project_Names

[psudireddy]

Hi All,

Fighting with this issue for long time.
Have report soon to my manager.

::here is the question:
I have a large database.......
So my group has 20 members.........

I have 3 tables........

1:tblProjects(Project_ID, Project_Name, Status)
2:tblTests(Test_ID,Project_ID,Tester, Tests)
3:tblscripts(Test_ID,Script_ID,Script_Name.....)


Now I have 3 forms……………….

One is being Updated by manager…………..(1.frmmanager)
Two is being updated by Tester…………….(2.frmtester)
3 is being updated by……manager(3.frmmanager_result)

So here 20 people are working on differe projects like ProjectA, Projectb, ProjectC.....later on they will be adding new project names...)

Now I have a main form: on main form I have ComboBox or ListBox(Record source tblProjects and Control Source---Project_Name) and 4 command buttons

1.Manager(goes to manager form)
2.Tester(goes to Tester form)
3.Manager_result(goes to Manager_result form)
4.Goes to graph

So here the idea is the Tester or manager comes up open the database……Initially he goes to Main form…..from here Project_Name combo box…………..he can choose any thing like ProjectA, ProjectB, ProjectC……..After Update Event of ProjectA……I can ableo to go to any control on the main form and goes to that form(tester or manager or….forms) and populate the data related to ProjectA,,,,,or ProjectB) …………

Please any one can help me………….please…..
o

 

[JoeAtWork]

That last paragraph is really confusing - I don't know what you are asking. Ask us some specific "How do I?" questions and we may be able to give specific answers.