Hi Team – I want to understand how we can create a combination of lists and restrict the planning across only those combinations. Please go through below as an example case:
Let’s presume we have two lists: Product and Location.
- The product has 4 list items P1 to P4.
- The location has 2 list items L1 and L2.
- P1 and P2 are associated only with L1.
- P3 and P4 are associated only with L2.
I am thinking of creating a compound list as Product_Location which has the values as P1_L1, P2_L1, P3_L2, and P4_L2. This will be a numbered list.
My question is: how do I associate this compound list with the individual list items so the planning is restricted only at the relevant combinations. As an example, how does the value of P1_L1 refer to the value P1 from Product and value L1 from the location? This question also means that the user shouldn’t be able to select L2 as the list item for Location when he chooses either P1 or P2 for the 'Product' list in the page selector.
Thanks for all the support,
Regards,
Guru