Include Related Records in Table Search

[innodat]

Is there a way to include information from related records in a search? Some auto enter field maybe which aggregates content from fields from related records?

For example I have a listing of exhibitions. When searching for exhibitions, I would like to be able to search for the name of an artwork, which is not stored in the exhibition table, but related through a join-table.

This would allow the user to quickly get a listing of all exhibitions which contain a certain artwork.

Any ideas how to do about this?

[bcooney]

Place the related field on the layout that you use for searching.

[innodat]

That's it? I'm embarrassed...

Just tested it, works great. This will change the way I program -)