In your frame information table, you could make a calculation field called 9pinspareindicator that looked something like this:
if ( ball1 = 9 AND ball2 = 1 ; "1" ; "0" )
This would give you a field that you can summarize (instead of count) through a relationship to give you your total (IE, if a bowler had 3 nine pin spares, his10 frames would be 1,1,1,0,0,0,0,0,0,0 in that calculated field for the 10 frame information records related to the bowler. You could then "sum" this field through a relationship to get 3 on the other side).
If you wanted to do a more complex calculation, you could use a case() statement to calculate a spareIndicator field, IE:
ball1 = 9 and ball2 = 1 ; "9pinspare" ;
ball1 = 8 and ball2 = 2 ; "8pinspare" ;
ball1 = 7 and ball2 = 3 ; "7pinspare" ;
ball1 = 6 and ball2 = 4 ; "6pinspare" ;
ball1 = 5 and ball2 = 5 ; "5pinspare" ;
ball1 = 4 and ball2 = 6 ; "4pinspare" ;
ball1 = 3 and ball2 = 7 ; "3pinspare" ;
ball1 = 2 and ball2 = 8 ; "2pinspare" ;
ball1 = 1 and ball2 = 9 ; "1pinspare" ;
"not a spare"
Hope this helps to put you in the right direction.
Also, didn't see the date of your original post, hope this was still relevant...
I want to ask your help to improve my database design, an EMR for Optometrists in our locality.
For each patient record, I have created a layout with 50 tabs representing the date of the visit of the patient on that day.
That means, if a patient makes his eyeglasses one a year, the tabs will be useful for the Optometrist for 50 years.
But if a patient makes a visit every 6 months , it will be usefull only for 25 years.
You can just imagine that the tabs run across the entire monitor in it's length.
I know that my design is quite funny but I don't know how to solve this.
All I need is that for every patient, he will have unlimited number of visits on his record.
Please help me.
Thanks a lot and God bless.
Hi Kroywen19. You should only post relevant topics inside of threads, if you're interested in asking someone for help or consultation privately, you should go to that person's profile and choose "send private message"