Show 2 Fields in 1 List Box

[#1]

I have 2 fields which are both lists of countries. I want to show both the lists in 1 list box. There is overlap between the 2 lists so that I will not want duplicates to be shown.

Is it possible to show 2 lists in 1 list box?

Thanks for your help.

Andy

[Anonymous]

You mean you want 2 lists to be one list??

In the load you should already combine these two ...

[#3]

Hi AndyMercer,

While loading load one field in first time, then second field in again.

let country1 and country2 are the two fields ina same table....

LOAD

country1 as

con

FROM

(

biff, embedded labels, table is Sheet1$)

;

LOAD

country2

as

con

FROM

(

biff, embedded labels, table is Sheet1$)

;

hope this will help you..

regards

bharathe

[#4]

Hi Bharathe,

I dnt get you on the above answer, cos i was also think for a same question ..........plzz if can u explain briefly

because i think , i have to combine two fileds and alias it. thn show it in list box.

[#5]

Ashwin,

if you are having 2 fields say(country1 and country 2) in a same table, then load one field (i.e country) alone in first with alias name con.

this can be done by

LOAD country1 as con

FROM

(biff, embedded labels, table is Sheet1$);

then load the table again only with second field (i.e country2) in the edit script with alias name con

this can be done by

LOAD country2 as con

FROM

(biff, embedded labels, table is Sheet1$);

then go to sheet objects... list box.. field(con)...

u can get data of country1 and country2 in the same field con.

[#6]

This is my source file ...

country1 country2

ind china

aus US

eng jap

Having country1 and country2 as fields....

Type the following code in edit script

LOAD country1 as con

FROM

(biff, embedded labels, table is Sheet1$);

LOAD

country2 as con

FROM

(biff, embedded labels, table is Sheet1$);

Here we are loading each field with alias name....

After reloading the script.... Go to sheet objects... listbox... then in fields -con.

You will get the following list box

con

--------

ind

aus

eng

china

US

jap

I hope you ll understand now... reply if this works....

regards

bharathe