Constructing a custom value list?

[Chalkster]

i am trying to create a value list that lists the values from the field that I require plus an "ALL" value.

I thought I had it worked out, but find that when I add a new value in the table it does not update my caculated list.

I have a table Zones which contains zone ID (unique) airline to which the zone belongs (which can occur many times)and a list of city codes that apply to this zone.

When viewing the records through a portal I want to be able to show zones listed per airline plus the ALL to show all zones regardless of airline

What I am trying to do is to creae a value list that lists all iairline codes in the table plus the "ALL" value... and that if a zone is entered with a new airline code the list should automatically update nad if an airline is longer used in any zone record then it is removed from the valuelist.

What I tried was to create a value list that listed all currently used airlines from the airline table and then used a calc field

" ALL" &

[Vaughan]

Base the value list on a field... in your case, airlines.