J
joeljkp
I have a linking table with the following structure:
Project Organizations
--------
ID
ProjectID (links to a record in Projects table)
OrgID (links to a record in Orgs table)
RoleID (specifies a role)
Each of these Project-Org pairs can appear several times, to specify that a
given organization has multiple roles in the same project. So example data
might be:
1 Project1 Org1 design
2 Project1 Org1 supplier
3 Project1 Org1 contractor
4 Project2 Org1 design
etc...
I have a form for the Projects table where I can input details about that
table. I want to include a subform that lists all the organizations
associated with that project, and the roles they perform.
But I don't want to list Org1 on 3 different rows with different roles.
Instead, I want two subforms, one of which has the list of organizations
(without redundancies), and the other which has a list of roles for the
currently-selected organization.
Is this kind of thing possible?
Project Organizations
--------
ID
ProjectID (links to a record in Projects table)
OrgID (links to a record in Orgs table)
RoleID (specifies a role)
Each of these Project-Org pairs can appear several times, to specify that a
given organization has multiple roles in the same project. So example data
might be:
1 Project1 Org1 design
2 Project1 Org1 supplier
3 Project1 Org1 contractor
4 Project2 Org1 design
etc...
I have a form for the Projects table where I can input details about that
table. I want to include a subform that lists all the organizations
associated with that project, and the roles they perform.
But I don't want to list Org1 on 3 different rows with different roles.
Instead, I want two subforms, one of which has the list of organizations
(without redundancies), and the other which has a list of roles for the
currently-selected organization.
Is this kind of thing possible?