DeeEmm
Member
G'day all,
Not 100% sure if this is a bug or simply a design limitation.
I have been trying without success to set up a table that includes a one-to-many relationship with another table that itself includes a one-to-many relationship with a further table. The issue I am experiencing is that whilst the first join shows on the main form, the second 'cascading' join is absent.
By way of an explanation, here is an outline of what I am trying to do
I have 3 tables: Tasks | Steps | Tools.
Each Task can have multiple Steps
Each Step can use multiple Tools
I have set these up using a one-to-many relationship as per the tutorial.
Tasks is joined to Steps as follows - left JOIN steps ON tasks.id = steps.taskid
Steps is joined to Tools as follows - left JOIN tools ON steps.id = tools.stepid
If I view the Steps form I can see the option to add multiple tools, However, if I view the Task form, whilst I can see the option to add multiple steps, within each step there is no way to add any tools. This part simply does not display.
I've been searching through the forums but have been unable to find an answer.
Is what I am trying to achieve possible? If not, how are people dealing with handling similar data relationships?
Ideally I want to keep all data entry on the same form without having to browse to another page.
I have attached a couple of screen shots to help explain. First one simply shows the Steps form with the option to add additional Tools. The second one shows the Tasks form with where I would expect to see the option to add tools.
TIA
/DM
Not 100% sure if this is a bug or simply a design limitation.
I have been trying without success to set up a table that includes a one-to-many relationship with another table that itself includes a one-to-many relationship with a further table. The issue I am experiencing is that whilst the first join shows on the main form, the second 'cascading' join is absent.
By way of an explanation, here is an outline of what I am trying to do
I have 3 tables: Tasks | Steps | Tools.
Each Task can have multiple Steps
Each Step can use multiple Tools
I have set these up using a one-to-many relationship as per the tutorial.
Tasks is joined to Steps as follows - left JOIN steps ON tasks.id = steps.taskid
Steps is joined to Tools as follows - left JOIN tools ON steps.id = tools.stepid
If I view the Steps form I can see the option to add multiple tools, However, if I view the Task form, whilst I can see the option to add multiple steps, within each step there is no way to add any tools. This part simply does not display.
I've been searching through the forums but have been unable to find an answer.
Is what I am trying to achieve possible? If not, how are people dealing with handling similar data relationships?
Ideally I want to keep all data entry on the same form without having to browse to another page.
I have attached a couple of screen shots to help explain. First one simply shows the Steps form with the option to add additional Tools. The second one shows the Tasks form with where I would expect to see the option to add tools.
TIA
/DM