auto replace field values from another table

[trhq]

I am very new to Access. I am working on a small program -
i know it sound so simple to most of you.

Anyway, I can't figure out how to do the following things.

My table/form (Main) has the following fields;
Name
Address
City
State
Zip
Networth

I have a separate table (ZIP) that has fldZip, fldState and fldCity
< used in form as: SELECT [Zip].[fldZip] FROM Zip; >

How do I auto replace the City and State when I entered Zip
on the Form. I was able to get the Zip but do not know how
to replace the City and State automatically when I pick on ZIP.

And, how to I replace the value of Networth to zero if given value is
negative.

I can share my Complete USA Zip Table if you can help me. Thanks

TP

 

[Jeff Boyce]

If you already have a list of City & States that correspond to a given Zip,
why do you need to record them redundantly in the main table? A simple
query joining the Zip in Main with the Zip in your lookup table will give
you the City & State.

Good luck

Jeff Boyce
<Access MVP>

 

[trhq]

some of the zip codes have a different city from what i have on zip table.
i made it that way to allow user to change the default city that corresponds
to zip code.
the form file use a flat file (it does not relate/link to any table).

TP