Search on join field

Content

Our customer has a join field on Opprtunity from Account. As this is an Account field, it's searchable there but the customer wants it searchable on Oppty as well. Join fields aren't searchable right now, there is a future approved change for it though. I've asked Oracle support if there is a workaround but they state it's not possible. Tried some things myself and indeed without luck. The only option i can think of to try now is create a custom text field, and an object trigger for create, and one for edits on the Oppty object which then looks