Linked forms

[FJM]

Name: SKMBT_36141121104000_0001.jpg  Views: 22  Size: 171.5 KB  ID: 18803" class="size_large" />

I have created the form above which has 3 tabbed pages. On the page shown I want to click on any row of the Section column and open up to a new form which will then allow me to enter further sub DETAILS which will be linked to the particular section which has been chosen. The DETAILS will come from a LOOKUP TABLE
The details need to be linked to each individual employee. I am having difficulty in designing the new DETAILS form as I cannot get the link to the individual employee
Any help is appreciated

[June7]

I use only VBA, like:

DoCmd.OpenForm "formname", , , "ID=" & Me.tbxID

A good event for this might be the form DblClick.

[ssanfu]

How are you trying to open the form now?
What is the record source for the details form?

[FJM]

The tabbed form you see is based on the following table
TRAININGSECTION
ID - Autonumber
SECTION -Number
TRAININGSTATUS - Text
DESCRIPTION - Memo
FINISHDATE - Date
EMPLOYEEID - Number
%COMPLETE - Number
STARTDATE - Date
DUEDATE - Date

Each SECTION will be designed to have a number of tasks within it.
Typically they can be
TASK A
TASK B
TASK C etc

Each employee can belong to any section and also each employee can then complete each individual task

What I am trying to design (without success) is to be able to select a Section on the tabbed form (which is shown) and this will then open a form which will allow me to enter details of the individual tasks for each individual employee.
I will then want to create reports based on employees, Sections, tasks etc
I can design a form to open, but my difficulty is linking it to the individual employee
My problem lies in the design of the table for the TASK form as I don't know how to link it properly to the TRAININGSECTION table so it links both the section to the task and also the employee ID

[June7]

Data relationships not clear to me.

Employee is assigned to a section and you have a table of these assignments? This table has unique record ID? That same employee performs tasks for each assigned section? Tasks should be associated with that junction table's ID, not the employee.

[FJM]

I am having a bit of difficulty in explaining this and so if if I explain what I am trying to achieve, it may help.
In an existing database, I am trying to show the details for each employee of the training which they have had. The training is within a number of sections and within each section there can be a number of tasks.
a) I have a department which is made up of a number of employees
b) In the department there are a number of sections
c) Each employee can belong to every section
d) Every section contains a number of tasks - the tasks are unique but can be in more than 1 section
I want to design the forms so that :-
a) I can see the details for each employee (this is the form I have shown)
b) I can show for each emplyee the training details for any section they are involved with
c) Within each section I also want to be able to show the details for each employee of their training.
I have designed the first employee page, but am having difficulty in the link between the section details and the tasks
I hope this explains things a bit more

[June7]

Not really. Doesn't change my assessment.

Have you built an entity relationship diagram to show how these items relate to each other?

[FJM]

I haven't built a relationship diagram because that is at the essence of my problem - I don't know how to best form the link between the Section details, the tasks and the employees to give me what I want
I was hoping that someone could show me how to join the tables.

[June7]

Have to describe the data relationships (or the business process if that viewpoint helps).

Employees are assigned to Sections. Each employee receives training pertinent to a section. Part if this training involves tasks.

Is any of that close?