Help - State Code Table

Hi. I'm in the process of setting up a membership database for our Legion,
Sons & Auxiliary. I bought the Access 2007 all in one reference for Dummies
as I had never working in Access or a true database program before.

I saw something in the book that sounded interested. It suggested that you
create a seperate table with the State Codes & State Names and use this
information to validate/lookup the info on the main table. I just printed
out the list from the USPS web site that includes this information along with
some other interesting info.

In my test file, I went to create a new table. The book said I could add
existing fields from another table. It wouldn't work. So I went ahead and
created the fields myself and input the state information into the table.

Now what? I can't figure out how I use this or even if it's really
necessary. Just trying to make things accurate but also easy.
Lisa

Lisa,

When you create the forms for data entry, you can use the lookup table to
validate the data entered by creating a combo box, basing the box off your
state lookup table and setting the field to be "Limit to List" so that no
value can be entered in the state field that does not exist in your lookup
table.

Once again, be sure to keep special characters and spaces out of your names.

Jackie

"Lisa - NH" wrote:

Hi. I'm in the process of setting up a membership database for our Legion,
Sons & Auxiliary. I bought the Access 2007 all in one reference for Dummies
as I had never working in Access or a true database program before.

I saw something in the book that sounded interested. It suggested that you
create a seperate table with the State Codes & State Names and use this
information to validate/lookup the info on the main table. I just printed
out the list from the USPS web site that includes this information along with
some other interesting info.

In my test file, I went to create a new table. The book said I could add
existing fields from another table. It wouldn't work. So I went ahead and
created the fields myself and input the state information into the table.

Now what? I can't figure out how I use this or even if it's really
necessary. Just trying to make things accurate but also easy.
Lisa

Jackie,

Ok, so that table wouldn't be used until I get to the Forms creation.
Thanks. I have printed your response for later when I am at that point.
Lisa

PS. I look forward to hearing back from you on the other posts. Sorry they
are so long and detailed.