Say I have a 'master-child' relationship between two tables and that one attribute of the 'child' table is 'color'. How can I set things up so the user can easily search to find all 'master' records for which any child record has a color of 'green'? This may be blindlingly obvious to others but it's befuddling me today. I realize I could create a view and have them search the view, but I'd like to keep the interface as simple as possible for whatever kind of adds, edits and searches the users want to do. Creating a view, and a menu item for a view, just for searching is thus undesirable.
Any advice would be most welcome.
= Mike =