Append data using two seperate tables

  • Thread starter Thread starter Dennis Hansen
  • Start date Start date
D

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
 
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];
 
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
Click to expand...
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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
Click to expand...

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?
 
Back
Top