C
chimaera
Morning,
I am building a database to manage prospective candidates against roles. One
of the problems I am having is in the "candidate record" form that i created,
I have an embedded "continuous forms" Subform that should show all the
candidates related to the role displayed in the main form. When more than one
candidate is allocated to a role only one candidate appears in the subform. I
think the problem my rest with the Join Conditions between my "Candidates"
and "Roles" Tables?.
The joins I am looking for need to be one to many ie multiple candidates can
be related to one role. The join I have is based around "RM Number" in Roles
(being the primary key and an "Autonumber") and the "related role 01, 02 etc"
fields in Candidates.
Any help would be greatly appreciated, as have been working on this problem
for a few days now.
Kind regards,
I am building a database to manage prospective candidates against roles. One
of the problems I am having is in the "candidate record" form that i created,
I have an embedded "continuous forms" Subform that should show all the
candidates related to the role displayed in the main form. When more than one
candidate is allocated to a role only one candidate appears in the subform. I
think the problem my rest with the Join Conditions between my "Candidates"
and "Roles" Tables?.
The joins I am looking for need to be one to many ie multiple candidates can
be related to one role. The join I have is based around "RM Number" in Roles
(being the primary key and an "Autonumber") and the "related role 01, 02 etc"
fields in Candidates.
Any help would be greatly appreciated, as have been working on this problem
for a few days now.
Kind regards,