Search in a Categorized view

Hi!

I have a form with a button.

The button displays a view which is being called using a DBLookup with a “key”.

I need to search in this view using the default Search in Notes Client.

Since the view returns only the second column up to the last, i cannot search through it using the default Search in Notes.

Also the column sorting were gone when I called a view using a DBLookup with a key.

I badly need help on this as I have tried some work arounds already and have no luck still.

I would appreciate some inputs/suggestions on this.

Thanks.

Machu