multiple filtering in reporting from tables -report viewer

See more:

C#

ASP.NET

Need to filter in order to report as follows.



Country ::


Branch ::


Sector ::


The Country table has the Field :: Country_Name which feeds into a drop down list box on the form.

The Branch table has the field :: Branch_Name which feeds into a drop down list box on the form.

The Sector table has the field :: Sector_Name which feeds into a drop down list box on the form.



The master table :: Master has the following fields

1. Acc_No
2. Name
3. Country_Name
4. Branch_Name
5 Sector_Name
6. Amount


Need to filter by firstly populating the 3 drop down list with the records from the various tables (i.e. Country,Branch, Sector).

Thereafter the filtering will be on the 'Master' table,


Question.

1 How do I Code the form with the 3 Tables to fill the drop down list , and then to filter the 'Master' table for reporting?

Thanks