G
Graham
Hi, I’m trying to get a subform to work to display up to say 6 selections
(job skills) held on a separate table, as per this article:
http://allenbrowne.com/casu-23.html
I have my Client Name & Surname, + a Primary Key in Table1 (PK1)
I have the list of Skills + a Primary Key in Table2 (PK2)
I have set up Table 3 with it’s own Primary Key (PK3), + PK1 + PK2.
I have created a One to Many relationship between the PK in Table1 & PK1 in
Table3, also a One to Many from the PK in Table2 to PK2 in Table 3.
I have also reset the Fields PK1 & PK2 as the combined PK in Table3.
The FormSkills is bound to Table1
The subFormSkills is bound to Table3
The combo cboSkills on subFormSkills gets its values from Table2
The FormSkills appears to work OK, it picks up the Names & PK from Table 1
and displays them, and I can navigate through OK
The Field in Table1 also appears to update OK. There has appeared a + sign,
and when you click, a drop down box appears with the PK from Table3 & the
correct PK’s from Table2
However, in the subform combo although the skills are showing, they remain
the same for each Client as I cursor through the FormSkills, and when I add a
selection for a particular Client, it adds to the combo and carries forward
to the next Client. I presume if I kept going I would eventually end up with
the cboSkills displaying ALL the Skills ALL the time ?
I’m almost there but something obviously needs tweeking, can anyone help ?
(job skills) held on a separate table, as per this article:
http://allenbrowne.com/casu-23.html
I have my Client Name & Surname, + a Primary Key in Table1 (PK1)
I have the list of Skills + a Primary Key in Table2 (PK2)
I have set up Table 3 with it’s own Primary Key (PK3), + PK1 + PK2.
I have created a One to Many relationship between the PK in Table1 & PK1 in
Table3, also a One to Many from the PK in Table2 to PK2 in Table 3.
I have also reset the Fields PK1 & PK2 as the combined PK in Table3.
The FormSkills is bound to Table1
The subFormSkills is bound to Table3
The combo cboSkills on subFormSkills gets its values from Table2
The FormSkills appears to work OK, it picks up the Names & PK from Table 1
and displays them, and I can navigate through OK
The Field in Table1 also appears to update OK. There has appeared a + sign,
and when you click, a drop down box appears with the PK from Table3 & the
correct PK’s from Table2
However, in the subform combo although the skills are showing, they remain
the same for each Client as I cursor through the FormSkills, and when I add a
selection for a particular Client, it adds to the combo and carries forward
to the next Client. I presume if I kept going I would eventually end up with
the cboSkills displaying ALL the Skills ALL the time ?
I’m almost there but something obviously needs tweeking, can anyone help ?