Hello all,
Quick summary of database structure:
I have a database used to keep track of test data and results that has a seperate table for Projects, Test Cycles and Test Cases. The relationships are Test Cycles to Test Cases: Many to Many and Projects to Test Cycles: Many to Many. This is because there are some default Test Cycles that I want to be able to add to Projects so one Test Cycle can be a child of many Projects and the same with the Test Cases (i.e. one Test can be used in many Test Cycles). I'm using two junction tables to manage the many to many relationships from my main tables.
The problem I have is that I want to be able to provide a count of how many test cases are assigned to each project. To do this I need to figure out how to cycle through each Test Cycle associatted with the project and have a cumulative total. The Cycles associatted with each project are displayed in a Listbox on the projects form.
I've browsed the forum already but can't quite find anything that helps me understand what I need to do. Anybody any ideas on how to do this?
Your help will be much appreciatted!
Cheers
Quick summary of database structure:
I have a database used to keep track of test data and results that has a seperate table for Projects, Test Cycles and Test Cases. The relationships are Test Cycles to Test Cases: Many to Many and Projects to Test Cycles: Many to Many. This is because there are some default Test Cycles that I want to be able to add to Projects so one Test Cycle can be a child of many Projects and the same with the Test Cases (i.e. one Test can be used in many Test Cycles). I'm using two junction tables to manage the many to many relationships from my main tables.
The problem I have is that I want to be able to provide a count of how many test cases are assigned to each project. To do this I need to figure out how to cycle through each Test Cycle associatted with the project and have a cumulative total. The Cycles associatted with each project are displayed in a Listbox on the projects form.
I've browsed the forum already but can't quite find anything that helps me understand what I need to do. Anybody any ideas on how to do this?
Your help will be much appreciatted!
Cheers
