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.
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.
Forms can be nested, up to 7 levels I think.
What exactly is the issue?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
That is a huge help. Thank you so much
Glad it was helpful, and thanks for the star.That is a huge help. Thank you so much