Hello,
I've seen this type of thread already in this forum but I can't find any replies that answer my question:
Put very simply I have two tables e.g "Names" & "Teams".
Names table:
ID_field (primary key), Name_field, Extn_field
Teams table:
TeamID (primary key), Name1_ID, Name2_ID...