I work with an NGO organization in my small town that I live in.
The government has now tasked us to assess small scale businesses in 5 of our district for capability and viability screening purposes. This will be done every year.
About 5 groups of criteria’s (60 criteria) were given to us as a tool to measure against the businesses performance. The criteria will also have a yes/no option next to it to determine whether they qualify or not for each criteria with a corresponding score out of 5.
I am tasked to build a database to store the results of the survey.
I am trying to set up the table relationships and the form a simple GUI but stacked. Please help me out.
What I want is:
A main form with business/company details with a cmd button to open a second form with the results of the survey for the business assessed.
The second form (results form) it will have a combo filter containing the names of the 5 categories so that when the category name is selected the form will display the corresponding criteria with its scores and the yes no value next to each of the criteria.
I have already created 3 tables. (1) tbl_business - for Business details (2) tbl_main_category - names of the 5 categories (3) tbl_criteria – all the 60 criteria entered
The table tbl_main_category has one to many relationship with tbl_main_category.
Now designing the form is very difficult for me with the above mentioned table structure.
I need some expert advice on going forward. Pls help
Thank you.