J
Jennifer K.
I have some strange problems happening with some lookup lists created in a
table using the Lookup Wizard.
I have a field for State of Residence [GRES] that is a number field
(integer, 2 characters). I have a separate table that has three fields that
include state name, state abreviation, and the number code that we store to
represent a state. For example:
STATE ST_ABBREV CODE_STATE
Alabama AL 1
Arizona AZ 2
Arkansas AR 3
California CA 4
..
..
Canada - Alberta AÂLTA 55
Canada - Saskatchewan SÂASK 55
The person entering data should be able to choose California and have the
number 4 stored as the value in the field. Anything in Canada would be stored
as 55.
What is actually happening seems to be that the text "California" is being
stored and not the number. Somehow it seems to be changing the Data Type from
number to text.
Also, when I try and delete that field from the table it tells me that I
have relationships that need to be disposed of before I can delete. Even
after I have eliminated those relationships it continues to give me that
message and not allow me to delete the field. If I manage to leave the table
and then re-open it than I can delete the field.
For the states this has been an aggrevation, but there is a larger lookup
that needs to be used that looks at place name and uses a code that specifies
the actual town and county using a code. For example:
TOWN_NA PLACE_NA CTC_CODE
SHOREHAM LAPHAM BAY 118
An event that takes place in Lapham bay should be coded as 118 to represent
Shorham in Chittenden County. Instead of storing 118 it is storing the text
Shorham.
Insight into what is going on and a solution would be VERY much appreciated.
Thanks,
Jennifer
table using the Lookup Wizard.
I have a field for State of Residence [GRES] that is a number field
(integer, 2 characters). I have a separate table that has three fields that
include state name, state abreviation, and the number code that we store to
represent a state. For example:
STATE ST_ABBREV CODE_STATE
Alabama AL 1
Arizona AZ 2
Arkansas AR 3
California CA 4
..
..
Canada - Alberta AÂLTA 55
Canada - Saskatchewan SÂASK 55
The person entering data should be able to choose California and have the
number 4 stored as the value in the field. Anything in Canada would be stored
as 55.
What is actually happening seems to be that the text "California" is being
stored and not the number. Somehow it seems to be changing the Data Type from
number to text.
Also, when I try and delete that field from the table it tells me that I
have relationships that need to be disposed of before I can delete. Even
after I have eliminated those relationships it continues to give me that
message and not allow me to delete the field. If I manage to leave the table
and then re-open it than I can delete the field.
For the states this has been an aggrevation, but there is a larger lookup
that needs to be used that looks at place name and uses a code that specifies
the actual town and county using a code. For example:
TOWN_NA PLACE_NA CTC_CODE
SHOREHAM LAPHAM BAY 118
An event that takes place in Lapham bay should be coded as 118 to represent
Shorham in Chittenden County. Instead of storing 118 it is storing the text
Shorham.
Insight into what is going on and a solution would be VERY much appreciated.
Thanks,
Jennifer