I have two tables - Table - 1 and Table - 2. Table - 2 fetches (lookup) values from Table - 1 based on the selection.

Table - 1 has manager details for various teams, and Table - 2 has multiple projects. Now the managers keep changing for teams over the years (but the team remains constant), and in Table - 2, I want to select the team name, and it should fetch (lookup) the manager details. But when I update the manager name in Table 1, it automatically changes the above records' lookup values to the current manager name. How can I keep the old manager details associated with the old project name?