List Box - Combining Two Data Fields

[Anonymous]

Hi -

I have a data set that has columns for Home State and Business State.  I am interested in creating one list box based on "State" that users can limit the results to.  For example if someone selects Vermont from the list box....I want it to return any one who has a home or a business address or both in Vermont within the result set.

Is this possible?

I appreciate any insight you can provide.

Best,

A

[effinty2112]

Hi Ashley,

A Search object might give you what you need. Add a search object with the two fields you want to search against and try it out.

Good Luck

Andrew

[vishsaggi]

With QV associative logic when you select any value from a list box it will be reflected and show the relevant possible values for the selected. Where exactly you want to show this data like in a table or other objects? Can you share a sample if possible with some expected output.

[manas_bn · Accepted solution]

May be: Create another column by concatenating HOME and BUSINESS States. Then add a List Box and change default search mode to Wildcard. Whenever you search in the new column, any row with HOME OR BUSINESS in that state will get picked.

Fact:

//Precedding load.

//Concatenate both Home and Business into "States" Column

Load *,Home&'-'&Business as States;

Load * inline

[ID,Home,Business

1,VA,VA

2,VA,MN

3,CA,VA

4,CA,MA

5,IL,CA];

Result: (I searched for *VA*)

Cheers!

[Anonymous]

I didn't know about the search object feature! This would definitely work, but for the application I am building I needed it to be shown as a list box.

Many thanks!