Updating one table based on another

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have two tables. tblLarge has 2000 records and tblSmall
has 49 records. Both have the same fields -- Name,
PlayerNum, and Score. tblSmall has the Names filled and
tblLarge doesn't. How can I easily fill the names from
tblSmall into tblLarge?

There is no PlayerNum in tblSmall that is not also in
tblLarge. Although in tblSmall the PlayerNum appears only
once while in tblLarge the PlayerNum field is not unique.

Sounds simple but it beats me!

Thank you.
 
Ken,

It's indeed very simple, all it takes is an update query, BUT... it is also
very wrong! This beats the whole idea of relational databases. Don't store
names in the big table, just join the two and retrieve them from the small
one.

HTH,
Nikos
 
Thank you, Nikos. I will give the method you recommended a
try. I think what I should do is relate the two tables and
then display them in a query and then build a form based
on the query. That way I should be able to see the data in
a form. I hope this is what you meant.

I appreciate your time and help.

Ken
 
Back
Top