Is it good enough to search for a hit on the child and then offer up a link to the Parent PDS? if so just put in a search widget and do that. The child records will have a link back to the parent PDS.
But If you want to have the users get there in one click, then roll up all the SKUs up to the Parent PDS with a Combined Text Summary field on the relationship. Then set the search widget to search the PDS table against that field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
