Thanks for setting me straight, Rick! I see now that this is a possibility,
but, in my particular situation it is unlikely the users will be able to
manage the advanced filter grid; I just want them to be able to do basic
sorts and filters. Still, I am happy to be wrong if I can learn something
new!

Fred

Actually you can, but it requires code or the use of the advanced filter
grid.
The reason is that you have to use a subquery like...

BookID In(SELECT BookID FROM Authors WHERE AuthorName = "Joyce")


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com