Table Relationship assistance and form GUI design

[karekare]

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 to

About 5 groups of criteria’s (60 criterias) 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 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.

[Rabbit]

You will need at least one more table. An assessment table that links the business to each criteria. A many to many that you will use to store the results of each criteria for each business.

That's the table you will populate with your form.

[karekare]

Thanks Rabbit. I have created the 4th table following your suggestion (tbl_Assessment_Details)

Now,this is how I have created the relationship.

A. tbl_business having one-to-many to tbl_Assessment_Details and

B. tbl_Assessment_Details having Many-to-One to bl_main_category.

C. bl_main_category having one-to-many to tbl_criteria.

Is that ok for me to proceed to GUI design now -from your point of view.

Many thanks!

[Rabbit]

Swap the criteria and main criteria tables in B and C. That will be the minimum you will need to start. But you should spend some extra time now to flesh out the entire database design rather than just the core. It will save you time and trouble down the road.

[karekare]

Thanks Rabbit. i will proceed with the GUi design.
Will post back if I am stucked on my way.

Thanks once again