Search a Value from a Field in Another Field

[#1]

Hello,

I have the following table:

ID	DESC_COMPLETE	DESC_REDUCED
001	SECURITY - BROKEN SHIELD	SECURITY
001	CONTRACT - MISSING TAG	SECURITY
001	EXTRA - OTHERS	SECURITY

What I want is to search the value in field DESC_REDUCED (SECURITY) in the field DESC_COMPLETE (over all the values) and bring the one that matches with the corresponding one (SECURITY - BROKEN SHIELD).

Is there any way to do that?

Thank you!!!

[tresesco]

Perhaps, you are talking about associative search. In the list box for DESC_COMPLETE right click->properties->General tab->Default Search Mode -> Set to 'Use Associative search'.

[#3]

Thanks, that would be useful if I had to select the value DESC_REDUCED. But I would like to have one single line in the table with the corresponding value and don't show the other ones.

[tresesco]

With default search mode - don't you get the similar? if you search 'SECURITY - BROKEN SHIELD' in the Desc_Complete field and press enter the single row with value gets selecetd to filter the associated security. Am I missing something?