[AccessD] Help with an Access web app -- finding records without matching related records

[Susan Harkins]

Setup - I have a small Access web app tracking errata for a technical
publisher. As books are published, I entered a few details. After a few
months, I contact the author asking if we need to publish an errata list. A
web app is perfect because the other authors have access and it was simple
to create. 

 

I have a books table, a contact table, and an author table. (I have others,
but they're not relevant to this discussion.) Books being the primary entity
- and the view displays all book data plus the author's name as a foreign
key value from the author table. The view also displays a list of contacts -
which is often blank. Some books have many contact records; some have none. 

 

I need a view that will display books with no contacts. It's been a long,
long time since I've done any serious Access work and I think I'd have used
a NOT EXISTS subquery to do this in a regular desktop database. Correct? 

 

So if "Susan's Guide To Using Access Web apps" is published but I've not
contacted Susan, I want a quick view that will list her book - not just this
one of course, but all books that I haven't initiated any contact with the
author yet. 

 

I can't seem to do this in a web app - there has to be a way to display
books that have no contacts yet. I hope I'm just making this too hard. 

 

Susan H.