Hi Naomi,


a CA is better:
-no need of a DBC
-may be changed without changes to the DBC
-may be changed in runtime without increasing DBC size.

my .01 USD
Agnes
>Hi Mohammed,
>
>If you want it to be quicker and change every time you change any of the names, you need to make it a local parameterized view. You can also make it a cursor adapter with parameters. I think local view in your case probably would be easier solution.
>
>>thank you for reply
>>How about simply 'use' the 'x2' table(?) and then just work with 'set filter to...' which reacts on the users input in interactivechange? You could create filters like 'set filter to (left(name1,2) == "An")' where "An" is the current Value of your textbox. And with each new character generate a new filter.
>>
>>i have text1, text2,text3 and text4 as names
>>
>>i need to make filter for name1 and name2 and name 3 and name4 at text1,text2,text3 and text4,at interactive change or any events
>>
>>