Looking for some guidance, I seem to be caught in the weeds.
I want to do a search on fields in a master/detail relationship.
E.g. manufacturer owns many parts. I want to search on the
manufacturer name, part name and part number, then return the full set
I have tried to use the .find method and create my own model .find
method using a SQL statement, but then the results do not get properly
mapped back to the objects.
What is the accepted strategy for this simple query?