automatically copying data from one table to another

[20sunflower]

Hi

How do I automatically copy data from one table to another? I have a table with player information and want to put the membership number into the fixture table automatically to avoid entering all the player ID numbers again.

 

[John Big Booty]

You could use an Append Query.