Update 1 field based on user input

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have 2 tables. Table1 contains Customer Information
Table2 contains Vendor Information. The fields in each
table are as follows..

Table1 Table2
Customer ID InstallCo
Name Contact Name
Zip Phone
Installer
Phone

What I need to do using a button on a form which displays
information from Table2, when the user clicks on a button
called assign it will prompt the user to enter a zipcode.
Once the user enters a zipcode the Installer field in
Table1 where all the records in table1 have zipcodes that
match what the user has entered, gets updated with
InstallCo information. Is there a way to build an update
query for this I'm stuck and need help with this. Thanks
in advance.
 
Your description contained below with the information about your problem is
a little confusing with the facts as there is little to breakup the
difference between what is a step and background information that is or is
not needed for contribution towards the answer of the specific problem which
I do not know if I clearly understand.

Thus, you may need to rephrase. Use lots of punctuation and direct, concise
facts.

I think that you want to populate the InstallerID in Table1 based on the Zip
code. Unfortunately, I don't see a zip code field in Table 2 (which appears
to be the Installer table), and also doesn't have an InstallerID (which is
what I think you want to put into Table 1)

Finally, I don't know how you plan to resolve if there are more than 1
installers in the same zip code.

Please feel free to provide more information.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top