I have a Case object which has 'Category' picklist with values 'Plumbing','Electrical' etc to handle the issue customer is reporting. Need to have a child object 'Parts' and it needs a Parts Picklist with values 'Pipe' ,'Elbow joint' , 'Switch','Wire'. We need the 'Parts' picklist on child object to show only the relevant values based on selection of 'Category' at case level. Is this possible at all using configuration or will this need a Lightning component ?
Tried workflows, flows to stamp the parent value on the child record but it simply doesn't constrain the child picklist while the record is being created first time. Subsequent edits do respect the constraint.
Any advice on how to proceed ?
Thanks.