Many to many relations / Combobox

  • Thread starter Thread starter nicola
  • Start date Start date
N

nicola

Hello
I have a many-to-many relationship and have therefore defined 3 tables:

Table Students (1 to many to Table StudentsSports)
Studen_ID (Primary Key)
Surname
Firstname

Table StudentsSports
StudentSports_ID (Primary Key)
Student_ID (Number)
Sports_ID (Number)

Table Sports (1 to many to Table StudentsSports)
Sports_ID (Primary Key)
Sport

When I create a Form using the Form Wizzard I don't get a Combobox in my
subform (Sports) as I should get in order to be able to select the various
sports for the various students. I tried also the Subform Wizzard but have
the same problem. It's a simple sample as desribed in the Access Training
Library but I don't get the result I would like. Can anybody give me a hint?

Thanks and best regards
Klaus
 
Hi nicola,
you need to create the combo in the subform by yourself. The wizard won't
automatically create it.
Select the textbox that needs to be a combo and on the format menu you can
change it from a textbox to a combobox.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
It works now - Thanks a lot for your helpful and fast response and best
regards Nicola
 
Back
Top