A function for counting record

Hello Everybody

I've a filemaker database with a field surname,a field family ,a field
with seat at cinema and a field Floor
example

Surname Family Seat Floor

Red Red seat n.1 1
Red - wife Red seat n.2 1
Black Black seat n. 3 1
Black -Son Black Seat n. 4 1
Green Green seat n. 10 2
White White Seat n.18 2
White - Son White Seat n.19 3
White - Wife White Seat n.20 3

I have another table with filed family and Floor fields indicating the
total booked seat for a family in a

floor

Family First_Floor Second_Floor Third_floor

red 2
black 2
green 1
white 1 2


How can calculate automatically the second table with filemaker?

Does exist a funciton like Count IF?

Best regards

Re: A function for counting record

"elisacarli" schreef in bericht
news:9600779c-fc70-4201-a97d-5623b2e779a7@z72g2000hsb.google groups.com...
> Hello Everybody
>
> I've a filemaker database with a field surname,a field family ,a field
> with seat at cinema and a field Floor
> example
>
> Surname Family Seat Floor
>
> Red Red seat n.1 1
> Red - wife Red seat n.2 1
> Black Black seat n. 3 1
> Black -Son Black Seat n. 4 1
> Green Green seat n. 10 2
> White White Seat n.18 2
> White - Son White Seat n.19 3
> White - Wife White Seat n.20 3
>
> I have another table with filed family and Floor fields indicating the
> total booked seat for a family in a
>
> floor
>
> Family First_Floor Second_Floor Third_floor
>
> red 2
> black 2
> green 1
> white 1 2
>
>
> How can calculate automatically the second table with filemaker?
>
> Does exist a funciton like Count IF?
>
> Best regards

Start with creating a relationship between first_table_Family and
second_table_Family
then create a field in the second table cCount [ calculation, number, count
( first_table_Family ) ]
and you are ready.

Keep well, Ursus