Hello All!
I must start by saying Access is rather new to me. I am more of an Excel guru but am starting to dip my feet into Access and am in need of a little help. I have created 2 tables. One is roster file that lists all of our current athletes including their unique ID #, name, and group. Obviously on this table the ID # is the primary key. On the second table I possess the exact same fields (with other columns) but cannot use a primary key on this table because this is where I place all of my athlete lifting data. Many athletes test multiple (could be unlimited) times so the ID # field must be able to accept duplicates (hence, can't be a primary key). So one table possesses all individual athletes, and the other table possesses all testing data for all athletes.
So here is my issue, whenever classes change I must change the "group" field on the Roster table for all athletes. I created an update query to update all records to null/blank. But now when I go to the Roster table and input an athlete's new group I want it to update all of the athlete's test records "group" field on the testing table. This way I don't have to go into the testing table and update all of these records.
Specific example would be if Steve Jones has his data on the Roster table and has 6 records of testing on the testing table, after all "group" fields are cleared using the update query I want to be able to update Steve's group on the Roster table and have this same value show up on all 6 records on the testing table.
Is this possible without a primary key on the testing table? If anyone knows a way to achieve this I would GREATLY appreciate it. Again, I am very new to Access so you may need to provide detailed steps. Thanks!
ND