How to use parts of one table in multiple tables.

[ndb]

I have quite a limited knowledge of MS Access (2007).
My question is; How do you use sections of one table in other tables?

For example: In tbl_One I input a users Name and Age and then say Weight, Height, BMI, etc.
Then in tbl_Two it uses the same Name and Age in tbl_1 but has other information such as Job, Skills etc.

This is not my actual database, however this analogy works, and they must be in separate tables, even though above they could all just be in a single table.



Thanks in advance,

[pbaldy]

In a properly normalized database, you wouldn't. You'd store the key value from table 1 in table 2, not any of the data. You'd pull them together with a query.