Create a form from three tables

[Shamli]

Hi
I have three tables.
1. Employee
2. Projects
3. Task

I have to create a form with the employee list and when a employee is selected,
one tab should display the employee information (Logid, contact details etc),
other tab should display the list of projects . I am planning here a drop down . I have to allot a project to the employee selected from the list.

Other tab should display the list of tasks. And the same process to be done. Like the employee selected to be allotted the task.


And when all the data is entered. it should be saved to another new table.



I am new to access. Can someone help me in starting with it.

Thank you!

[ranman256]

these would be subtables.
1 single record form for Employee
1 subform for tProjects that shows the 1 employee a list of projects he is working
1 subform in subProjects to show what task in the 1 project for the 1 employee.

you could use the listbox to add tasks to the project. (run append query when user dbl-clicks the listbox)

[pbaldy]

Welcome to the site. FYI, I deleted your duplicate thread; please don't post the same question multiple times.

[Shamli]

Duplicate.

[Shamli]

Thanks for replying.
I have a question here.
Once the employee is selected. The project sub form should display all the projects (Projects where the employee is working as well as all the other projects too). I am planning here a check box.
The goal is to see what projects he is working as well as the admin can add projects under his name.

To explain this in elaborate.
Ultimate purpose is for timesheet management.
Current Problem:
Employees have access to all the projects and tasks in the timesheet form. SO many are filling the timesheet for the projects they are not working.
To be Done:
So I have the following tables. Employee table, Project table(This has the list of all the projects) and the task table. (There is no common field between all the three tables)
I have created a table (Assign Employee to Project) which links the employee and project table.
Now when the admin chooses the employee, he should be able to see the list of projects (Projects where the employee is working as well as all the other projects too).
So in future the admin can add an employee to a new project and save that into the "Assign Employee to Project" table.

I hope I explained my problem here.

[June7]

Conventional form design options:

1. Single form bound to junction table "AssignEmployees" with comboboxes to select employee and project

2. Main form bound to Employees, subform bound to AssignEmployees with a combobox to select project

3. Main form bound to Projects, subform bound to AssignEmployees with a combobox to select employee

[pbaldy]

A technique that may help when assigning projects/tasks:

http://www.baldyweb.com/MultiselectAppend.htm

[Shamli]

Thank you so much for your reply. I will try this one.

[Shamli]

Thank you for the sample. I will try them and see.

A technique that may help when assigning projects/tasks:

http://www.baldyweb.com/MultiselectAppend.htm

[Shamli]

Thank you so much. It worked.

A technique that may help when assigning projects/tasks:

http://www.baldyweb.com/MultiselectAppend.htm

[pbaldy]

Happy to help!