I am just increasing my skills to include Notes and have hit a problem...
I have created a database containing company records and project records.
3 records are company records with ids COMP_A COMP_B COMP_C
3 records are project records with id PR_1 PR_2 PR_3
My companies are associated with the projects in one or more of 3 roles and so the project form contains fields ROLE_1 ROLE_2 ROLE_3 into which any of the companies can be put.
How do I create a categorised view which demonstrates the projects with which the companies are involved. It needs to look something like:-
>COMP_A
>PROJ_1 as role_1
>PROJ_3 as role_2
>COMP_B
>PROJ_3 as role_1
>PROJ_2 as role_2
>PROJ_3 as role_3
>COMP_C
>PROJ_2 as role_1
>PROJ_3 as role_2
Obviously a standard view with a select of all the projects will only return 3 records whereas there are 7 in the above. I want it to reselect all projects whenever a Company twisty is opened.
I have created a database containing company records and project records.
3 records are company records with ids COMP_A COMP_B COMP_C
3 records are project records with id PR_1 PR_2 PR_3
My companies are associated with the projects in one or more of 3 roles and so the project form contains fields ROLE_1 ROLE_2 ROLE_3 into which any of the companies can be put.
How do I create a categorised view which demonstrates the projects with which the companies are involved. It needs to look something like:-
>COMP_A
>PROJ_1 as role_1
>PROJ_3 as role_2
>COMP_B
>PROJ_3 as role_1
>PROJ_2 as role_2
>PROJ_3 as role_3
>COMP_C
>PROJ_2 as role_1
>PROJ_3 as role_2
Obviously a standard view with a select of all the projects will only return 3 records whereas there are 7 in the above. I want it to reselect all projects whenever a Company twisty is opened.