Append data using two seperate tables

[Dennis Hansen]

Help!! I have a inventory tracking system that records a
history trail for my inventory. I need to update 2000
records using the numbers from a separate table. The
numbers have no duplicates they are unique. And will
match numbers I want to record new information to.
Some of the id numbers may show up a hundred times in the
data base. And I need that information. I want to use the
numbers in the separate table to append a new record
reflecting the new transaction. I don't want to do this
manually. Please guide me in the correct direction. The
data base is in Access 97
Thank you

 

[Ken Snell]

In order for anyone to give you a suggestion that's close to being "on
point", you'll need to give us more details about the structure of the
tables and how they're related. You can use an update query to make the
changes; structure of the query's SQL statement will be similar to this:

UPDATE [TableName] INNER JOIN [OtherTableName]
ON [TableName].FieldName = [OtherTableName].FieldName
SET [TableName].AnotherFieldName = [OtherTableName].[AnotherFieldName];

 

[John Vinson]

Help!! I have a inventory tracking system that records a
history trail for my inventory. I need to update 2000
records using the numbers from a separate table. The
numbers have no duplicates they are unique. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
And will
match numbers I want to record new information to.
Some of the id numbers may show up a hundred times in the

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I'm feeling dense tonight but... aren't these two statements in direct
contradiction?

data base. And I need that information. I want to use the
numbers in the separate table to append a new record
reflecting the new transaction. I don't want to do this
manually. Please guide me in the correct direction. The
data base is in Access 97
Thank you

An Append query should work but... I'm not at all sure I understand
your table structure, nor which information you wish to append to
which table. Could you describe your tables (key fields only), their
relationship, and provide an example of what information you want to
change or add?