I
Ianb
Hi
I have an interseting problem with a form/subform. I am building a
competency database. For each given competency there are a range of grades so
that 'French' as a competency might have the choices 'basic,
intermediate,conversant,fluent,expert' and the competency 'Car licence' might
have 'learner, full'
the table schema is
tblCompetency
Name pk
Description
Type
etc...
tblCompetencyGrade fk pk
CompetencyName pk
GradeName
Description
etc...
so then I want to create a master/ sub form to present this information. I
firstly built the form manually then used the wizard and in both cases I get
the same perculiar error. the CompetencyName field on the subform gets
defaulted to the name of the master talbe... ie 'tblCompetency'. If I change
the name of the table the new name is defaulted into the field. This means I
can't use the form for adding new records as this field is hidden and is in
the primary key of tblCompetency. If I take out the hidden field I get the
same error.
Can anyone help with this
Thanks
Ianb
I have an interseting problem with a form/subform. I am building a
competency database. For each given competency there are a range of grades so
that 'French' as a competency might have the choices 'basic,
intermediate,conversant,fluent,expert' and the competency 'Car licence' might
have 'learner, full'
the table schema is
tblCompetency
Name pk
Description
Type
etc...
tblCompetencyGrade fk pk
CompetencyName pk
GradeName
Description
etc...
so then I want to create a master/ sub form to present this information. I
firstly built the form manually then used the wizard and in both cases I get
the same perculiar error. the CompetencyName field on the subform gets
defaulted to the name of the master talbe... ie 'tblCompetency'. If I change
the name of the table the new name is defaulted into the field. This means I
can't use the form for adding new records as this field is hidden and is in
the primary key of tblCompetency. If I take out the hidden field I get the
same error.
Can anyone help with this
Thanks
Ianb