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

Susan Harkins ssharkins at gmail.com
Sun May 22 10:59:17 CDT 2016


Criminy. nevermind..

 

I have no idea why the query I was using wasn't working, now it is.. Timing
I guess. Is anyone else having web app issues like this? I publish it, it
doesn't work. a few minutes later, I publish it again and it does? Just
me???? 

 

Susan H. 

 

 

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. 



More information about the AccessD mailing list