Im trying to build a custom job board search on visualforce. I have a positions object which has a relationship has a master detail field to account.
I'd like the search to return positions when you search for company (account names). I know you can use SOSL to search multiple sObject types but id rather it always just return positions. So i made a simple formula field just pulling the org name to the position but it doesnt seem to work.
When i create a text field and then have a trigger fill that in that works fine.. but the trigger feels a lot messier...
is there a way to do this with formulas that will work? or better yet is there a way to search all the "related" fields and still return the specific object?