Thread: Updating one table from another

Ok, this is the first time I'm trying something like this, so I don't have a frame of reference to start from. I hope I am explaining this properly:

I have a source of data for equipment. This source cannot be changed by me (it's automated). I have made a query to pull needed equipment information from it to generate reports/labels.

One of these sets of labels need added information added to it (for servicing and supplies), but this information cannot be added to the source. I was hoping to be able to pull the needed data from the source (which I have) into a new table. Then to this table add a few more fields (service and supply info), which again I have done.

The tricky part is that the source data does get updated (as new/old equipment is changed), and I would need these changes reflected in my new table. Is it possible to update the table from the source without having to make a new table. I would hope that the fields would stay. I would like the new equipment to be appended to the end of the table, and deleted items (probably the tricky part) removed.

Thanks for the quick reply. The data orginates from an ODBC source.

As a first step, I have tried using the Make Table query to pull out the specific data that I need (model, serial number, asset number, etc.). This data is created through a diffrent system that is updated as equipment is purchased/decomissioned.

So I have my new table. To this new table, I need to add servicing info (such as service vendor, supplies needed, etc.). It looks like I will have to manual enter this information for each item.

Now, when items are added/removed from the source, I would like these changes reflected in the table I have made/adjusted without losing the udated info added to the remaining data.

I hope this makes it more clear.

The reason for creating the new table is because I need to add information specific to our region (meaning corperate wants this info tracked but does not want to play with the source tables, so this stuff is done manually in excel at this time).

To give an example, information I am importing will look like this:

| Asset# | Serial # | Model | HBU | Install Date | EOL|

when printing the labels and reports, I need more info that this. to this current field list, I would need to add:

| Service Agreement | Supplies | Contact Info |

(there are more fields, but I hope you get the idea)

This latter info is what is being created manually, as the above data is pulled from the source into excel. Each time we pull the data, we have to put back in the Service data manually, which is getting to be a pain. We are about to make a large turn over of equipment, and I want to make the process less painful.

I guess I was thinking too complex... You are right. I could make a table that has the asset # that could be linked back to the source in a query, then output that to a report.

This would still mean maunally adding the asset #'s in the table. I guess I can't get away from that. My issue is knowing what has been added or removed. I was hoping that I could have access do that for me.

My end result (one of the key ones) is a label that would go on our printers so that isolated site offices would know what to do/who to contact when problems (supplies or service) arise with the equipment. As it is now, there are various avenues when it comes to service depending on where the equipment is, when it was bought and the model.

It seems a lot simpler that it started out to be. Thanks for clearing that up. Guess I should start with thinking small, then expand on it. I might have been too focused on the final product...

Will try and set that up today, and let you know how it goes. Thanks again.