Thank you CJ London.
You are talking about what is sometimes called a Many to Many Junction/Join Table?
My TblPlayers is structured how you show it as being structured. I just failed to mention I have PK (autonumber).
I was only saying that the Players Table won't be normalized into First...
I am new to Access and Databases and fairly new to forums over the past year so hope I post correctly.
I have been normalizing a Sports Card database which will eventually hold thousands and thousands of cards and it is more complex than one might think. My question revolves around multivalued...