hi,i could not think any possible solution...so please help me...here is my problem..
i have a table like this..(MONTHLY REPORTS)
1. District name
3. No.of total case register
4. no of unspecificed case
5. no. of suspected condition
9. name of disease condition
here is where i lost my self..
Point/column 1 to 5 has to be enter once in a month and 6 to 10 can be any number of records for that month.
point 5 is the number of records enter i.e. nos. of records enter for point 6 to 10.
Also how to make constrains on the table so that reports can be enter monthly-wise. But a single month can contain multiple data.
So how will i create the table structure...plz help me..i don't know any other possible solution(not at all).