Append Fields from one table to multiple

  • Thread starter Thread starter Don M
  • Start date Start date
D

Don M

I may be asking too much here (I'm a newbe).
I have a table that has all zipcodes and area codes. I
want to populate fields associated with the above that has
information from another table. For example, I would like
to have every zipcode that has area code "213" populate
the "best bakery," "best chiropractor," "best etc.." So
the form would ask for the area code, I would use combo
boxes (since the various bakeries, chiropractors, etc. is
already stored in another table) and when appended, the 28
lines that have "213" as the area code would now have the
above fields populated with the choices from the vendor
table. Is this possible???
Thanks!
Don M.
 
An update query will allow you to populate values in one table, based on
values in a second table.

I do not understand the rest of your objective.


--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Sorry... What I have is a number of rows that contain zip
codes (42000+) and Area Codes (quite a bit fewer since
many zip codes can be in an area code). I was hoping to
build a query (and therefore, a form) where I could enter
an area code (i.e. 213), provide data for another field in
that table/row (preferred vendor) and the result would be
to append the entered "preferred vendor" into ALL of the
rows that contain the identified area code (for example,
choose 213 as area code... enter in "Don" as the preferred
vendor, and every row that has 213 in the area code field
would add "Don" in the field listed "preferred vendor."
So the row would then have: "zip code," "213," "Don" on
every row where area code = 213 -- an no other area codes.

Hope this helps... and thanks, Don
 
Back
Top