Thanks in advance for your assistance on this...
I am using Mac OS X 10.5 and FileMaker Advanced 8.5
I am working for a film festival in assigning sponsors to each film in
the festival according to the interests of the organization
I have five databases...Two main databases, Organizations and Films, a
Keywords Database, and two databases for assigning keywords
I assign the same keywords to Organizations and Films through the
keywords database. These assignments are stored in two assignment
databases that list the Organization ID/Film ID, depending on which
one it is, and the Keyword ID, and I am able to show them in a ****tal.
When I am in the films database, I am able to set up my relation****ps
so that I can see list the organizations that have at least one of the
keywords I have specified for the film, but I want to set it up so
that it shows ONLY the organizations that have all of the keywords
specified.
This is driving me a little crazy, and I'm wondering if it's even
possible to do this.
Thanks.
David Averbach
|
