Pull data to another table

  • Thread starter Thread starter alexasha
  • Start date Start date
A

alexasha

I have couple linked tables. They are linked by ID. I would like to
automatically pull name and date of birth from table1 to table 2. I can not
figure out how to do it. Please help.
 
I have couple linked tables. They are linked by ID. I would like to
automatically pull name and date of birth from table1 to table 2. I can not
figure out how to do it. Please help.
Click to expand...

Don't.

Relational databases use the "Grandmother's Pantry Principle": "A
place - ONE place! - for everything, everything in its place". The
name and birthdate should be stored once, and once only, in the table
where it is unique to a person. If you need it in conjunction with
data from another table use a Query joining the two tables; pick up
the name and birthdate from the one table, and the other fields from
the other table.

Storing the information redundantly in the second table is neither
necessary nor good design.
 
Back
Top