This is how I want my page to look like :
Column A,B &C are drop down lists, dependent on each other eg:
What I would like to know is if and how can I get column D (top pic) to populate with all the "components" that match the "Works" Selection. So if I select Plumbing parts (Col C - Top pic) It will automatically list all the parts under Plumbing parts (Col E - 2nd Pic) same if the selection from the drop down is Tank Pad (Col C - Top pic).
I hope I have explained it clearly... Thank you.
Column A,B &C are drop down lists, dependent on each other eg:
What I would like to know is if and how can I get column D (top pic) to populate with all the "components" that match the "Works" Selection. So if I select Plumbing parts (Col C - Top pic) It will automatically list all the parts under Plumbing parts (Col E - 2nd Pic) same if the selection from the drop down is Tank Pad (Col C - Top pic).
I hope I have explained it clearly... Thank you.