Click here to Skip to main content
15,849,543 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Comments
Kornfeld Eliyahu Peter 5-Oct-14 1:43am    
http://mattgemmell.com/what-have-you-tried/
[no name] 7-Oct-14 12:59pm    
what have you tried for this

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900