Synonym based List box

[shyamcharan]

Hi Experts,

I have a requirement where I need to show the values in the list box that matches the synonym words.

For example:

I have a table with synonym words.

SYNONYM:

LOAD * INLINE [

    KeyWord, Synonym

    BW, BAYSWATER

    B Water, BAYSWATER

    LD, LIDDELL

    LDL, LIDDELL

];

FL:

LOAD * INLINE [

    Functional_Location

    Bayswater Power Station

    Bayswater Unit 1

    Bayswater Unit 2

    BW-BAYSWATER

    LIDDELL Power Station

    LD_LIDDELL

];

User would enter something like 'BW' in the Input box. This would in return fetch me the Synonym as BAYSWATER from the Synonym table and I would like to use this to search against the original field Functional location and display only related List of values.

Now, I would like to have a list box Functional Location that matches with the word 'Bayswater' as it has in the synonym table. but not all.

I have tried and attached the same but somehow i am unable to get the wildmatch worked.

Any suggestions on this would be really help ful.

Thank heaps.

Regards,

Shyam.

[agomes1971]

Hi,

really the problem is here:

=IF(WildMatch('*Synonymn*',[Functional Location])=1,'Good')

Synonymn this is supposed to be a variable?

Carefully watch to what you're doing you'll get there...

André Gomes

[mato32188]

Hi Shyam,

try attached file.

[tresesco]

May be like attached sample. Select in the KeyWord/Synonymn field and notice the listbox possible values.

[shyamcharan]

Hi Andre,

Sorry, Yes I was not sure on that.

I appreciate any help on that.

It is a column from the Synonym table.

Thanks heaps.

REgards,

Shyam

[shyamcharan]

Hi MArtin,

Creating a relationship does not work in my case. I would have many fields that would need to be searched for based on synonym's.

Regards,

Shyam

[shyamcharan]

Hi tresco,

I guess we are close but the user would not be selecting anything but just enter 'BW' and I want the list box to show only values that match the synonym words.

Thanks heaps.

Shyam

[shyamcharan]

Thanks Guys for the quick turn around.

But in my case I would not be creating a relationship to the Synonym table as I would have many fields that would be searched on.

Secondly, The list box would be displaying only the matching values and not all.

I appreciate any help on this.

Thanks heaps in advance.

Regards,

Shyam

[tresesco]

This?

[shyamcharan]

That was awesome piece work indeed.

I guess that just works out for me.

I would get this demonstrated to my user and see how it goes.

Thanks heaps Tresesco

Best Regards,

Shyam