L
Len
Hi folks,
Not familiar with Access but have been tasked to setup a "Repair" database.
The setup was pretty easy except:
On the form out of numerous fields three are essential
1)Zip Code 2)City 3)State
There are two databases:
Repairs & ZipCodes
Need to create a relationship and the proper controls to allow a user to
type in a 5 character Zip Code in the "Repairs" Form
then
Hit Tab
then
Have Access 2000 enter the City and State from the ZipCode Table when the
inputed numbers in the ZipCode field on the "Repair" Form match the 5 digit
set of numbers from the ZipCode Table!
I didn't think it would be so difficult to get a DB program to do what it
was designed to do!!
Ask me how to build a computer, configure operating systems and setup a
network and I'm fine... ask me to get a database to enter info in two
fields: City and State automatically and it seems like I'm lost.
Any assistance would be appreciated!
Len
Not familiar with Access but have been tasked to setup a "Repair" database.
The setup was pretty easy except:
On the form out of numerous fields three are essential
1)Zip Code 2)City 3)State
There are two databases:
Repairs & ZipCodes
Need to create a relationship and the proper controls to allow a user to
type in a 5 character Zip Code in the "Repairs" Form
then
Hit Tab
then
Have Access 2000 enter the City and State from the ZipCode Table when the
inputed numbers in the ZipCode field on the "Repair" Form match the 5 digit
set of numbers from the ZipCode Table!
I didn't think it would be so difficult to get a DB program to do what it
was designed to do!!
Ask me how to build a computer, configure operating systems and setup a
network and I'm fine... ask me to get a database to enter info in two
fields: City and State automatically and it seems like I'm lost.
Any assistance would be appreciated!
Len