I created two tables

tblOne has Team_ID & TeamName
tblTwo has Player_ID, Team_ID, and PlayerName

The ID Feilds are the Primary key and are autonumbered.
Team_ID is linked in a one-to-many relationship between tblOne & tblTwo

When I Import data into tblTwo it requires the Team_ID field to be an
Integer, but on the datasheet view it shows the text of the name the ID
relates to is this correct?

Is my database correctly storing only the integer and not the text. I assume
it is since the feild type is labeld as Number. I am trying to learn & use
correct relational database concepts. By that I mean I do not want to repeat
the TeamName or the PlayerName for that matter. I will use the Unique_ID I
created for them