Storing data?

[blee via AccessMonster.com]

Not sure if this should be in "Queries". I have a form w/ a combo box which
pulls up data from a table ("Athletes"). The data is then stored in a
different table ("Injuries") by an ID number. My question is how I can store
both this ID # as well as the last name in a separate field in the Injuries
table (to allow easier editing later).

Thank you for your help.

 

[Rick B]

Not sure what you are trying to do. In a normalized relational database,
you don't copy data from one table and store it in another. Instead, you
link to the other table.

In your example, you have a table of athletes and their data. This table
should include an "athlete number" or some similar key field. You also have
a table where you track injuries. In this table, you should store injury
information, and also the "athlete number" which is linked to your main
athlete table. You don't need to put the athlete's name in the injury
table. That would be redundant.

Hope that helps. If not, you might want to give us a specific example of
what you are trying to do.