I have 2 tables, the key field is the same in both, my need is to complete two fields in the 1st table from the fields in the 2nd table from the same key field. I don't know if this is the table relationship or query task and how to go about doing this?

Thank You
William

William,

Welcome to UtterAccess Discussion Forums.

Storing the same data in two tables is uneccessary and poor design. All you need in the second table is a field with the same data type and size as the primary key of the main table. You can then use a query to join both tables together.

Glenn