Three tables with many-to-many relationships. Subform within a subform?

[Didgeridoo]

I have 3 tables - Role, Task, Skill.
Each Role can perform multiple tasks and each task requires multiple skills.
I want to make a form which shows each task that each a role performs and also, which skills are required for these tasks.

[June7]

Forms can be nested, up to 7 levels I think.

What exactly is the issue?

[Didgeridoo]

I have successfully nested the task subform into the role form, so when I scroll through Roles and list of relevant tasks is displayed. I just can't then get the list of skills required for those task to be entered to. I have tried adding another subform but that just lists all skills and not only those relevant to the task selected.

[June7]

Sounds like data structure is incomplete - lacking junction table(s). If you want to provide db for analysis, following instructions at bottom of my post.

[Didgeridoo]

I have created junction tables and made a query but I don't know how to create a form that will show each task and skill (without duplicates) for each role.

[June7]

You don't want to use that query for forms.

Usually, a form does entry/edit for only 1 table.

There are no forms in db. Build form/subform(s) and use master/child links properties to synchronize related records.

To build a standardized set of Roles related to tasks:
Main form for Role and subform for Role_Task_Jnctn with combobox for selecting Task

To build a standardized set of Tasks related to skills:
Main form for Task and subform for Task_Skill_Jnctn with combobox for selecting Skill

Either pre-populate Role, Task, Skill tables or use combobox NotInList event to add records 'on-the-fly' during data entry.

[davegri]

Didgeridoo-davegri-v01.zip

Have a look at this. I changed the name of your keys and added autonumber prime keys where appropriate. Your query is not used.
Added 3 forms, a main form with a tab control. Each tab holds a junction table subform.
Quick and dirty to give you an idea how to elaborate/proceed.

[Didgeridoo]

That is a huge help. Thank you so much

[davegri]

That is a huge help. Thank you so much

Glad it was helpful, and thanks for the star.