Query that excludes records with no 'children'

[harris71]

Hello,

I'm relatively new access, and I have the following question:



I have two tables in my database, the 'sentence' table and the 'word' table. Each sentence entry can have several related words. I want a query that excludes sentences with no words linked to it, i.e. no entries in the related table. How do I do that?

Thanks

Harris

[rpeare]

if you have a PK in your sentence table and your word table carries a FK to the sentence table (PK = primary key, usually an autonumber, FK = foreign key) just link the two tables through the PK/Fk and put in a criteria in the WORD table (FK field will work fine) of IS NULL