不在（选择

DFS提供的出色响应可以通过点击 查询/新建并选择FindUnmatched Query向导。 This one droves me completely mad. I did not succeed to exploit thetrack given to me by Bob. I have :three tables : Clubs, Persons and ClubsPersons that join the two firstin a many to many relationship.Club has two (2) fields : ClubId (Autonumber) and ClubName (Text).Peoples has two(2) fields : (PersonId (Autonumber) and PersonName(Text)ClubsPersons has two (2) fields : ClubId (LongInteger) and PersonId(LongInteger). A form (frmForm) with one control. An associated subform(frmClubsMembers) for displaying the persons members of the aboveclub. The control on the subform is a ComboBox (continuous form). Queries : qryClubs which feed the frmClubqryClubsPersons for the subform.a query in the rowsorce of the combobox (My problem is with thisone...) What I want to see :When I click on the ComboBox, I want to see the names of the personswho are not yet members of the displayed Club. I tried various queriesin the rowsource of the combo, without success. The closer I came is with this query in the rowsource.:SELECT qryPersonnes.PersonId, qryPersonnes.PersonNom FROM qryPersonnesWHERE (((qryPersonnes.PersonId) Not In (SELECT[tClubsPersonnes].[PersonId] FROM tClubsPersonnes WHERE[tClubsPersonnes].[ClubId] = [Forms]![FrmClub].[ClubId]))) ORDER BYqryPersonnes.PersonNom; But it does not display the members. Other queries display the membersbut do not permit to update the tClubspersons. Others display membersbut update the wrong table. I have worked days on that. Please help. Many thanks in advance. 解决方案 The excellent response, provided by DFS, can be created by clicking onQueries/New and selectiong the FindUnmatched Query wizard. 这篇关于不在（选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！