1:1 relationship for sales title and plan ID will now be 1:many
We have a list called Sales Titles which has all of our Sales Titles. The code for each sales title is a plan ID. 1:1 relationship. Some sales titles have the same exact plan components, but just different plan IDs. We have a request that now they are reducing the number of plan IDs as some sales titles have the same plan. For example, there will now be 4 different sales titles but all will have the same plan, which will have the same plan ID. Our current system is built with this 1:1 relationship. Does anyone have any thoughts or ideas on how to build this new requirement or has ran into a new requirement like this?