Matching the Exact name..

[Anonymous]

Hi

I have two tables as follows,

Table1 :

Table1.name          Table1.mom    

sachin                           1

dravid                            2

kohli                              1

Table2 :

Table2.name          Table2.nickname    

dravid                            wall

kohli                              virat

sachin                            god

Here, consider i displayed all  Table1.name field in a list box object. (listbox-1)

and similarly displayed all  Table2.name field in another list box object. (listbox-2)

What i want is,

when i select any one name fromTable1.name from listbox-1, it should search for the same matching name in Table2.name and should select that reg exact match in listbox-2 also.

Constraint:

i. Without creating a unique key for each row( without associating two tables).

I know its simple, i tried, but somewhere i m missing some logic.!

Thanks.

[tresB · Accepted solution]

Try using trigger like in attached qvw.

[migueldelval]

Hi pandurangan,

Could you check this example?

Regards

Miguel del Valle !

[Anonymous]

IS there any other way, other than using triggers..

Like can we do it in an expression.??

[tresB]

You can use set analysis like:

=Only({<Name2=p(Name1)>} nickname)

If you select any value Name1 the text box with above expression would give you similar output from Name2's nickname.

[Anonymous]

thanks