Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
It was really hard to write a good subject for this, so I hope this one described it enough for people to come take a look.
What I want to achieve in CRM (online so latest version) is the following:
I have 3 fields: Product / Production plant / packaging
Based on the product, users should be able to select a certain plant that can produce it
Based on the Product & the plant, users should be able to select a certain packaging.
I am familiar with lookup - related records so I've been trying that like follows:Products table has unique products:Product AProduct B etcProduction Plant has the same plant multiple times but for different productsname of the plant - lookup to the product table:Plant A - Product A Plant A - Product BPlant B - Product APlant C - Product B
So if a user selects a product, they will see only the Production plants that are available for this product, without seeing a plant multiple timesNow comes the hard part, based on the Product & the production plant, the user should be able to select the packaging.My idea, or the only option that I could think of was to make a table with all the possible combinations of packaging, plant, productpackaging description - lookup to Production plant table:300 gram - Plant A (Product A)500 gram - Plant A (Product A)300 gram - Plant A (Product B)100 gram - Plant B (Product A) etc.It's a lot of work to maintain and the lookup filtering down twice is of course not as convenient to use as a option set.Any ideas to simplify this perhaps?
Thanks in advance!
Business Applications communities