Pick3 listing double numbers

[Raybaudi]

There were several errors:

1) the "Match" field was correctly formatted boolean, but with "inversed" values.

2) the relationship with "next" table was OK but you sorted the main table instead of the related "next"

MI_PICK_3.zip

[khank]

Thank you for the help from both you and LaRetta.

I'm going to "comb" over that "working" file to see where I mess up. I had already taken care of the "prior" yellow number working, but I was still having a problem getting the "MIDDAY" current number registering "green".

I did change this morning the "boolean" field. And I did change the "sort" on the relationship page. Still I was getting only 0's and 2's being highlighted. The match still wasn't correct.

Yours is working correctly - I need to study your file to see what I did wrong. Its gotta be in the relationship area.

Thanks again and I'll be in touch,

Ken

[khank]

Question on my Evening ID (see jpg).

You'll notice #1 and notice 1047.

How can I fix this, I was a little uncertain about this and I didn't want to lose anything.

It should read as 1 on 10/27/2007 (the beginning) and 1054 is the last number entered at 8/23/2010.

[khank]

Forget it, got this handled.

[khank]

There are 220 number permutations.

These number strings will be placed in a new table called "NUMBERhistory".

I'm stuck on how to locate a value from another field in another table and place a total for that value in this table.

Example: the drawn_number is a field in the Midday table where the 3-digit number resides. Example from the chart above the number 022 has hit 2 times.

The Excel formula I used for the above sample was: =COUNTIF(drawn_number,022).

What would the Filemaker function be?

Would I need to create a relationship with another table?

B, C, D, E – I know how to formulate those fields.

[Raybaudi]

Yes.

You'll need to relate the TEXT fields:

Midday::drawn_number and NUMBERhistory::drawn_number

Than a simle calculated field will do the job:

Count ( NUMBERhistory::drawn_number )

[khank]

I did that.

The relationship is linked between Midday::drawn_number and NUMBERhistory::drawn_number. I used the "=" for the link.

How do I get it relating to a particular number (example: 022)?

[khank]

After pondering this dilemma overnight a "light" popped on. (Even a blind pig will find food once-in-while.)

Since I'm dealing with number permutations - meaning a group of 220 individual numbers (which include 720 non-repeating, 270 doubles, and 10 triples). And these groupings contain 1-way, 3-way and 6-way number combinations.

I created fields: num1, DRAWNnum1, num2, DRAWNnum2, etc. The "num1" is on the "NUMBERhistory table, the "DRAWNnum1" needs to refer back to the "MIDDAY drawn_number field and COUNT the number of times that number has hit.

There is a "numTOTAL" field with the function of "num1 + num2 + num3 + num4 + num5 + num6" (adding up the total times that number permutation hit).

The other fields I added are called "pick1, pick2, pick3, and c3digit". The pick fields are where I choose individual numbers and c3digit is the concatenation of those individual pick fields into a 3-digit number.

The function you mentioned was a calculation of "Count ( NUMBERhistory::drawn_number )" wouldn't that be instead "Count ( NUMBERhistory, num1::MIDDAY, drawn_number ) :

I do have the relationship linked (MIDDAY and NUMBERhistory) with an equal sign.

The NUMBERhistory layout is picking-up ALL 1578 records from the "MIDDAY" table. That is wrong, I should have only 220 permutation records for this table.

Am I on the right track or totally outta left field with this?

[Raybaudi]

So you have 2 tables: MIDDAY and NUMBERhistory linked by the same text field in both tables: drawn_number.

Could you describe ALL the other fields of NUMBERhistory and who writes the drawn_number in that table ?

( I doubt that you need that new table )

[khank]

I've attached the file for your review.

Please let me know what I've done wrong.

I know or "feel" I'm on the right track, but I've missed something.

MI_PICK_3.fp7.zip

[khank]

ChindoguMaker;

Yes 2 tables linked by the same text field "drawn_number"

All the fields in the NUMBERhistory table are:

Num1

DRAWNnum1

Num2

DRAWNnum2

Num3

DRAWNnum3

Num4

DRAWNnum4

Num5

DRAWNnum5

Num6

DRAWNnum6

numTOTAL

pick1

pick2

pick3

c3digit

The MIDDAY field I want to "link" to is the drawn_number field, count and give me a total in the "DRAWNnum" field for a particular number. The "num" field is where I would enter the number I want to count.

I didn't go any further on my file because I was worried I would screw some of the records I already had.

Attached is a sample look at what I'm trying to do (note: don't worried about the border).

3way6wayCHART.zip