IMO your tables are likely not correct (aside from the fact that most developers won't use lookup fields in tables). Without much insight into the purpose of the db, perhaps should be more like
tblSeason
SeasonIDpk
Season
Week
tblTeams
TeamIDpk
TeamName
tblSeasonTeam
ST_IDpk
SeasonIDfk
TeamIDfk
MaybeOtherField
If that looks quite odd, then perhaps you should review db normalization.
Last edited by Micron; 08-02-2022 at 09:36 AM.
Reason: corrections
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.