Hi I was wondering if anyone could help me - at work we have been developing a few databases (with hardly any access training)
I'm not sure if I need to make a query or even maybe a macro - we have a ton of tables with part#'s that we download from our corporate site - we are wondering if there is a way off appending values (#'s) from one table to another?? say we have a single part# -what we want to happen is when access see's that particular part# it automatically appends the information from that part#'s table to the current one?? does any of that make sense????? I don't even know if appending is the correct term?
right now we are cutting and pasting records from one table to the next- we want it to automatically add the records that are in the corrosponding table - thanks

I think you are looking for an Update query. Search help for Update queries for some assistance in creating one.

I'm not wanting to update any information - I want an area (query/macro??) that pretty much says - if this part# is entered or seen within a table then go to a specified table(which is named for the part# entered) and take all that information in that particular table and add it to the bottom of that existing table you are working in-
Example:
I have 4 separate tables each named a part# (tbl1-4560-123) then we have a bunch of other tables & qrys (some union & etc)which connect all of our other tbls together - we download info. daily into our tables (all having the same structures) we want somehow ???? if at all possible, when the information is in our table it recognizes one of those 4 part#'s (that are named tbls) and grabs the info from the flagged # and puts all the info in that table at the bottom of all records - We don't want to change any information we just want to add records to a table that already has records in it without wiping anything out of it - is there any way of doing that? We can do it DOS but are we asking too much from access or too complex?
thank you

No you're not asking too much of Access. However you need to review your database structure I think.
The fact that you have four tables with the same structure, named after your different parts, gives me the idea you could consolidate here. Add another field, PartID (don't make it the Primary Key!) and you can filter this new table to get part-specific information, or work with the entire thing for accounting, inventory, etc. I think this will do away with a lot of your union queries. Find a good website on database normalization and start printing/reading - you'll be amazed I think at what you can do.

As far as importing data from other locales, look into the Import wizard. You can save a 'style' of importation once you've done it once, and largely automate the process with a few macros/code.

Lastly, don't get discouraged. I started working with Access completely cold about 6 months ago. It takes a while to get the differences between flat spreadsheets and relational databases, but eventually the light goes 'bing' and doors open.

Post back if you have specific questions. You've bitten off quite a bit to tackle here, but you'll manage IMHO.

Regards,
David R