Lookup without updating past records

[mshah72]

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?

[kuovonne]

You have to copy the lookup value to an editable field.

[mshah72]

I am aware of copying data to an editable field, but I cannot understand how to implement it. Can you please describe the implementation?