Many to many relations / Combobox

[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

 

[Jeanette Cunningham]

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

 

[nicola]

It works now - Thanks a lot for your helpful and fast response and best
regards Nicola