one Dropdown output as input to another dropdown

[Sruthi]

HI, 

In first drop down I need to display locations as location 1, location 2 etc. If i select Location 1,  the second drop down should list the meters of the Location 1. for ex. meter 1, meter 2 etc. If I select meter 1 the current and power values should be displayed in a LED widget.

Similarly for Location 2. How to do this? 

[PaiChung · Accepted solution]

You can use the DataSource / Selected Row(s) from the first dropdown and use that to set the SelectedItem(s) in the DataSource of the second drop down.

[Sruthi]

One more thing, If user-1 logs in then only  Location 1 should be visible to him in the drop down. whereas if user-2 and user-3 logs in all the Locations should be visible to them. Ho to do this?