Consider the following situation:
There are 3 Lists A, B, C each with a column called "client name"
There is another List D which has a list of 1000 client names.
I created a relationship field such that the column "client name" in Lists A-C can access client names in List D. However, since this relationship is on a list to list level, the information is lost incase a task is moved between List A-C. Is there a solution to this?
Is there a way to create a relationship, such that the "client name" value is not lost when we move the request from one list to another?