Building Summary Count into Lotto numbers DB

[zebbyz]

I have a simple number field structure db of lotto numbers and I want to analyse them with summary counts.

 

But i'm just getting a bit confused as to what I need to do to get it to work for me.

 

Lotto Balls 1, 2, 3, 4, 5, 6 and Bonus, and Power numbers

Lotto numbers 1 through 40 are available for 1 through 6. Meaning once a number is drawn it can't be redrawn in that draw.

Bonus Ball Numbers 1-40

Power Ball Numbers 1-10

 

So say draw numbers are :-

 

1st, 2nd, 3rd, 4th, 5th, 6th -  Bonus, Power

"26","33","39","12","31","36" - "17","8"

"7","14","30","23","2","33" - "5","8"

"20","38","3","17","10","16" - "32","8"

"14","25","19","38","34","13" - "8","1"

"3","32","5","22","19","13" - "15","3"

"20","1","10","36","21","6" - "32","3"

"32","1","2","37","36","24" - "14","1"

"4","29","23","15","9","6" - "7","3"

"27","5","38","21","23","30" - "36","2"

 

I have created a summary Field "Summary" and that counts 1st Ball drawn... it goes on as per pic attached but I am sure its not the right way to do it so I won't bother explaining "the wrong way".

 

I need to display in a live preview layout each number 1-40 per 6 draw numbers [with the count underneath] then the same for the bonus and power numbers.

 

Help appreciated !

Many thanks

g

[eos]

Try this for a start. Using related records instead of fields gives you much more flexibility.

 

If you want a live preview, create (via script) a new draw event with empty TypeInDraw slots; in one window show the Draw layout with the newest draw and a portal into TypeInDraw, in another window the summary layout (for a compact display use a version without the body part). Then fill in the new numbers in the portal and commit; the respective summaries (group/ball) will automatically change.

 

 

Lotto_eos.fmp12.zip