antimoneylaundering
New Member
- Joined
- Jul 9, 2015
- Messages
- 4
I'm an Access newbie (first time user) and am struggling with cascade boxes. I haven't been able to find anything that has helped me.
I am trying to create boxes with dependencies.
I have Stage.
Then Step which is dependent on stage.
Then Task which is dependent on stage.
The primary key for each is ID.
I have a table for Stage, Step, Task, and a full table (which is currently labeled Table 2) which contains information for everything.
When I go to look at it all of the options are available. For instance, if I select stage all steps are available rather than the ones that are only applicable to that stage.
Joins
Full Table to Task (Inner Join)
Full Table to Stage (Inner Join)
Full Table to Step (Inner Join)
Stage to Step (Inner Join)
I have the following query:
SELECT Table2.Stage_ID, Table2.Step_ID, Table2.Task_ID
FROM ((Table2 LEFT JOIN Task ON Table2.[Task_ID] = Task.[ID]) LEFT JOIN Stage ON Table2.[Stage_ID] = Stage.[ID]) LEFT JOIN Step ON Table2.[Step_ID] = Step.[ID]
WHERE (((Table2.Step_ID)=[Forms]![QA Form_Use_Old]![cboStep]));
Where am I going wrong?
I am trying to create boxes with dependencies.
I have Stage.
Then Step which is dependent on stage.
Then Task which is dependent on stage.
The primary key for each is ID.
I have a table for Stage, Step, Task, and a full table (which is currently labeled Table 2) which contains information for everything.
When I go to look at it all of the options are available. For instance, if I select stage all steps are available rather than the ones that are only applicable to that stage.
Joins
Full Table to Task (Inner Join)
Full Table to Stage (Inner Join)
Full Table to Step (Inner Join)
Stage to Step (Inner Join)
I have the following query:
SELECT Table2.Stage_ID, Table2.Step_ID, Table2.Task_ID
FROM ((Table2 LEFT JOIN Task ON Table2.[Task_ID] = Task.[ID]) LEFT JOIN Stage ON Table2.[Stage_ID] = Stage.[ID]) LEFT JOIN Step ON Table2.[Step_ID] = Step.[ID]
WHERE (((Table2.Step_ID)=[Forms]![QA Form_Use_Old]![cboStep]));
Where am I going wrong?