entry form
Thanks for the solution,but I guess I did not state the question clearly.
I'm creating a database that allows the management to assign tasks to the programmers and users.
This is the tables that I have
Request Assignment
~Request# (Primary) ~Request(com.key)
~UserID (Foreign) ~Project#(Comp.key )
~RequestDate ~Beginningdate
~Purpose ~EndingDate
Project Task
~Project#(primary) ~Project#(Com)
~ProjectName ~ProgrammerID(Com)
~DescriptionofProject ~Task#(Com)
~Task Description
Programmer
~ProgrammerID
~Name
These are the five tables that relate to each other. Assignment and Task are the associative entities. Relationship between Request and Assignment is 1 to many; Project to Assignment is 1 to many; Project to Task is 1 to many and Task to Programmer is Many to 1.
My form is that allow the management to assign project to the programmer. It means that whenever user click on the Add Manament info button, there should be a new subform that allow the management to fill in particulars.
I hope this information is helpful
Thanks for the solution,but I guess I did not state the question clearly.
I'm creating a database that allows the management to assign tasks to the programmers and users.
This is the tables that I have
Request Assignment
~Request# (Primary) ~Request(com.key)
~UserID (Foreign) ~Project#(Comp.key )
~RequestDate ~Beginningdate
~Purpose ~EndingDate
Project Task
~Project#(primary) ~Project#(Com)
~ProjectName ~ProgrammerID(Com)
~DescriptionofProject ~Task#(Com)
~Task Description
Programmer
~ProgrammerID
~Name
These are the five tables that relate to each other. Assignment and Task are the associative entities. Relationship between Request and Assignment is 1 to many; Project to Assignment is 1 to many; Project to Task is 1 to many and Task to Programmer is Many to 1.
My form is that allow the management to assign project to the programmer. It means that whenever user click on the Add Manament info button, there should be a new subform that allow the management to fill in particulars.
I hope this information is helpful