Find with Portal Tool
I have a simple database. Effectively it has an image with some basic meta-data about the image (i.e., publisher, dimensions, etc.). It has a related table for category. The idea being that you can associate the image with a number of categories. This is a 1 to many relationship. So I used the portal tool to allow for the data entry to associate multiple categories with the image. Works great! No issue there. However, when I go to do a find, I am only able to put one category entry in. What if I want 2,3 or 4 categories to be included in the query? What if I want this to be an "and" and later be an "or" query?