duplicate column from one table to the next

[Guest]

Can you please help me to duplicate one column, (let's say NAMES) from one
table to automatically appear in the other table i am creating without
retying it.

 

[Guest]

Hi, Albina.

I think the easiest way is to duplicate the entire table, and then delete
the unwanted fields.

HTH
Sprinks

 

[Joseph Meehan]

Can you please help me to duplicate one column, (let's say NAMES)
from one table to automatically appear in the other table i am
creating without retying it.

You don't want to copy the names. You form a relationship between the
tables so in a query, form or report you can use the names from the first
table as if they were in the second without copying them storing them etc
and you will avoid the problems that will happen if someone changes their
name (like gets married) or corrects a spelling etc and Access will work
better.

 

[Guest]

thanks, that's what i thought but was just wondering if there is a better way