Have to Show Values from two Different List box in one.

[#1]

Plz find the attached example .

Thanks!!

[Gysbert_Wassenaar]

Maybe like this: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

[Peter_Cammaert]

Is it possible to merge the two "Sizes" into a single field (in your script)?

A list box always references a single Field for its main display.

Peter

[#4]

No ..cannt merge two sizes  into single(in script..)

[Peter_Cammaert]

Because they refer to two different sets of products or something like that? Can you move those sizes out of the original tables to a common location like a link table?

Sorry about making guesses, but without a data model there is not enough info for us to solve this...

Peter

[#6]

Thanks Peter..

[#7]

I guess you can load the table twice. In first load take only one size field and in other load take the other size field and use Concatenate between them. Then in frontend apply sor order on numeric values to achieve what you want.

Load

[Size1] as Size

From

Table.xls;

Cancatenate

Load

[Size2] as Size

From

Table.xls;

This will merge the valus into one common field name Size and then you can use this field in your front end chart and apply the Numeric sort order form the Sort Tab in the properties of your chart.

Hope it Helped

[#8]

I guess you can load the table twice. In first load take only one size field and in other load take the other size field and use Concatenate between them. Then in frontend apply sor order on numeric values to achieve what you want.

Load

[Size1] as Size

From

Table.xls;

Cancatenate

Load

[Size2] as Size

From

Table.xls;

This will merge the valus into one common field name Size and then you can use this field in your front end chart and apply the Numeric sort order form the Sort Tab in the properties of your chart.

Please see the Attachment.

Hope it Helped