Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: A function for counting record

Posted on 2008-04-23 09:38:25 by elisacarli

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

Report this message

#2: Re: A function for counting record

Posted on 2008-04-23 21:43:29 by E W P Appeldoorn

"elisacarli" <elisacarli@katamail.com> 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

Report this message