Search a created field

I have a grid with a field which I created, called Notes. In the OnLoad event, I populate this field with data from another table. I would like to be able to include this field in the search criteria. I have been able to add Notes to the Advanced and Dynamic fields list (not the Quick Search) but upon compiling, (a) Dynamic search doesn’t offer the field for selection and (b) Advanced search doesn’t bring back any records when I try searching the Notes field.

You have to create the field either in the app SQL select statement or in a view in your DB.

AFAIK fields created inside the SC apps can’t be searched.