Hi all: Experimenting with the table class and relationships at the moment. Just been wondering what would be best for the following situation:
-Table Photos has 2 columns I want to search on (primary keyword id and secondary keyword id) -Table Keywords contains all keywords having a unique id -Table Keyword_variants contains keyword variants pointing to the primary keyword row. Now let's say I want to search for primary keyword "Church" and secondary keyword "Sanctuary" and I want to find all photos that have these 2 keywords assigned. How could that work using the table 2 objects primaryKeyword and secondaryKeyword. It doesn't appear to me that I can use the findDependentRowset function since I would have 2 objects. If it doesn't find the keyword in the primary keyword table, it has to check the keyword variant table to see if they are there. If it finds them in the variants table, it needs to look up the primary keyword id (which is in the variants table) and then look for the Photos. E.g. "Churches" in the keyword variant table would point to the "Church" keyword. Same for "Sanctuaries" pointing to Sanctuary. I know how to construct SQL statements to pull it directly from the Photo table. Just been wondering if there would be a good object oriented approach. TIA Gunter
