Lookup without updating past records

Topic Labels: Base design
693 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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?

2 Replies 2

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

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