This discussion is archived
1 Reply Latest reply: Oct 18, 2010 5:05 AM by PhHein RSS

Dependency between three lists

802850 Newbie
Currently Being Moderated
Hey

I am trying to implement a dependency between three lists.

Location && Industry && Manufacturer are dependent!

For example:

Manufacturer     Industry     Location
MOTORJIHLAVA,     Automotive     ,Czech Rep.
COMTE,     Automotive,     France,
FENOX,     Automotive,     Belarus,
NORTHSTAR,     Aerospace,     Canada
NORTHSTAR WIND,     Aerospace,     Canada
SHANGHAI_HUDON,     Aerospace,     Hong Kong
LUFTHANSA,     Aerospace,     Ireland
KNAAPO,     Aerospace,     Russia
FORJAFRIO,     Bearing,     Brazil
DAIWA,     Bearing,     Brazil
EURO ESSEN,     Bearing,     Germany
BAMAREC,     Bearing,     France
ZWL SLOVAKIA,     Bearing,     Slovakia

•     There is no order selection, meaning a location can be selected first then Manufacturer and finally Manufacturer, any order between the three lists is acceptable
•     If selecting first the location a list with all countries should be displayed without redundancies, If we will pick up " France " as a Location, Then the Industry List should be populated only with the following values: " Automotive" &&"Bearing", and the Manufacturer list should carry two values " COMTE" && "BAMAREC", the second selection can be any, Industry or Manufacturer, but in this sample we will chose the Industry = " Automotive", which will Filter the Manufacturer List to only one value list Manufacturer=" COMTE"

•     I am looking for the most efficient way to implement the above functionality!

Hope the Q is clear enough, I'll appreciate any help,
Thanks,
Natalie

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points