reducing record in drop down list box

[nizamsha]

Hi

i am using straight table with 5 field say name,city,address,country,city

i used drop down list box to all the 5 field but i question is in city i have four record say a,b,c,d

but i want to display only 3  record a, b,d in dropdown list box

when i click any one of the record may be a it should display the details of a only how can i do it

[#2]

Hi,

You can reduce in your script.

"

Tab_City_reduced:

Load City as City_reduced

Resident YOURTABLE

Where Match(City , 'Cityname1' , 'Cityname2', 'Cityname3' );

"

In listbox use City_reduced , select one .

Afther right click, properties and check "Always one selected value".

Hope it works.

[#3]

You can use a formula in the list box and then use an if(,,) formula to only display the wanted items.

In list box in the field where you select the field, scroll down until you reach <formula>. After selecting this you can insert a formula like "if([city] <> c;[city])".

[rustyfishbones]

Will this help