linking many to many

[surajap123]

Hi Experts,

I have a table of data.

I want to keep only those Products that belong to 'Art' Category and remove rest of the products from the dashboard ie. Product-'Newell 322' in this case.

All the Art products belong to Sector A1 and A2, as products and categories have many-to-many relationships.

My Requirement is, if a user select on Category 'Art', the sector A1 and A2 should be associated ie not greyed out.

Please help!

[surajap123]

Yes Triggers are fine.

Please help me.

[surajap123]

Thanks for your help.