Junction Tables

[fenlon]

I have 3 tables
1) People
ID
First
Last

2)Languages
ID
Language

3)JunctionPeopleLanguages
ID
PeopleID
LanguageID

I would like a way to present a form that would allow editing peoples' information and a check box for every language that could be checked or unchecked to indicate what languages they speak.
The junction table contains the language and people id pairs. I do not want to add language columns to the people field as new languages are added regularly to the languages table.

I guess I am looking for a select statement that would produce something like the following.

Code: Select all

ID  |  First  |  Last  |  Spanish |  English |  French | ...
1       Ben       S            0          1          1
2       Jane      B            0          0          1
3       Carl      F            1          1          1

Thank you for your help with this.

[RGR204]

Ik think you have to join the tables on the General tab for the form. Not sure I'm a newbie.

[admin]

fenlon,

You would be better off creating a Subform for each person and a Dropdown or lookup on each row, to select each the Language they do speak, not worrying about displaying languages they don't speak.

Steven