S
StargateFan
This is one that I've looked high and low for and I can't seem to
figure out what to do to fix things. I have a lookup table to provide
province abbreviations.
Column 1 is, of course, the primary key with A2K-generated numbers.
Column 2 in the table has the province abbreviations which consist of
two letters just like US states (i.e., BC stands for British
Columbia). The third column shows the complete names of the
provinces.
The idea is that users can see the second and third column in the
pulldown of the contact form so that they don't have to wonder if they
have the right province just by the 2-character letters; they have the
complete name, too. But I need the form to take the 2-character
abbreviation only, which it never seems to be able to do. I get the
display okay to show columns 2 and 3 and have successfully hidden
column 1, but nothing works to just get the 2-character province
abbreviation in the field.
Is there a way to do this?
figure out what to do to fix things. I have a lookup table to provide
province abbreviations.
Column 1 is, of course, the primary key with A2K-generated numbers.
Column 2 in the table has the province abbreviations which consist of
two letters just like US states (i.e., BC stands for British
Columbia). The third column shows the complete names of the
provinces.
The idea is that users can see the second and third column in the
pulldown of the contact form so that they don't have to wonder if they
have the right province just by the 2-character letters; they have the
complete name, too. But I need the form to take the 2-character
abbreviation only, which it never seems to be able to do. I get the
display okay to show columns 2 and 3 and have successfully hidden
column 1, but nothing works to just get the 2-character province
abbreviation in the field.
Is there a way to do this?