search in qv can filter only display certain table data ?

[paulyeo11]

Hi All

when i search for MY2 , this items have it in sales table , inventory table , opportunity table , inventory table.

but since the particular sheet is for user search for inventory table.

how can i limit the search only display items appear from inventory table ?

now is very confuse , as it list all table.

any work around ?

[swuehl · Accepted solution]

You can limit the search to certain fields in search object properties.

When you perform a search on a key field, you won't be able to limit it to a certain table, I believe.

If that's the issue here, you can potentially duplicate the key field values in that table, creating another field for searching that particular table.

[paulyeo11]

Hi swuehl

many thank for yr sharing.