Copy data - i need just two values - and place in another table - not a new row?

[Tiger1]

How do i copy data from one table ( i only need two column values) and place it in another row - not a new row? I want the new data to link to the corresponding key in the other table.

Table A - I want two columns copied
Table B - I want those two values placed in the linked row ( so it must go to the correct row)

[Steve]

Unfortunately, there’s no trivial way to do what you want.

You need the row in table B to perform an action to set its own column values from the desired column values of the row in table A. The action performed by the table B must be able to determine which table a row to use. For instance, if table B is a child table for table A, you could dereference the table B row’s parent Ref.

[Tiger1]

Would it be easier combining the two tables and just separate what i need in my views?

[Steve]

Not nearly enough information to say.

[Tiger1]

Ok.