Update Data in one table based on matching field in another table

[Guest]

I have 2 tables that both include ID numbers. Table 1 has payment data for
each record, which I would like to add to table 2, but the data being updated
in table 2 needs to match by ID number. example:

table 1
ID Payment
G67 45.00
F56 55.00

table 2
ID CltName Payment
G67 Joe would like this to be 45.00
F56 Jane would like this to be 55.00

I do not need to do this with a Payment field already in table 2. It could
be a query which I then make into a new table. I am just having trouble
getting the matching info to transfer. I have tried dlookup with no luck.

thanks

 

[Guest]

You should not be storing the payment value in two separate tables. Just
retreive it from table 1 when you need it.

 

[Guest]

This data is fake. I used this simple example because if someone can tell me
how to do this (instead of some random comment on where I should be storing
data), then that will show me what I need to do in my actual database.

 

[Pieter Wijnen]

The word to the wise still holds true, the only time you want to store
"redundant" data is in a transaction type table
ie "what was the cost of the item on this invoice at he time it was
invoiced"

Pieter

 

[Guest]

Once again, why would a person take the time to write something irrelevant??
This is not my real data or scenario, but if someone can tell me how to do
this I will be able to do what I need to do. If someone could attempt to
actually help with my question it would be greatly appreciated. I have tried
to make it very simple.

-Jake