Re: A function for counting record


"elisacarli" <elisacarli@xxxxxxxxxxxx> schreef in bericht
news:9600779c-fc70-4201-a97d-5623b2e779a7@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: On finding a cleaner Re: Needlepoint Fabric
    ... Don't touch the stereo cabinet - means DON'T TOUCH THE ELECTRONICS, ... back of the seat, the top of the seat, under the seat, the lid, under the ... around the rim and the surrounding floor. ... DO NOT PUT IT IN THE COAT CLOSET. ...
    (rec.crafts.textiles.needlework)
  • Re: Mounting for laptop?
    ... This thing mounts between a seat bolt and the floor apparently, ... laptop, you might want to look into a laptop with a solid state hard drive ... And without a dedicated dock mount that locks the laptop in place, ...
    (alt.autos.toyota)
  • Re: Anyone know where I can get a floor pan for an A2 Golf or Jetta?
    ... My floor rusted out to my surprise. ... the left side of the driver seat bottom went through the ... rivets a shaped piece of flat metal is usually underestimated IF you can lay ... rail can be also riveted to the new metal and the seat fits to slide back. ...
    (rec.autos.makers.vw.watercooled)
  • Re: 1993 sea ray laguna 18 advice
    ... My boat doesn't have a built-in livewell. ... the stern that are meant to have a seat on each. ... The floor and the cap of the gunwale are all in one piece. ... The boat didn't have a T-top when the original owner purchased it. ...
    (rec.boats)
  • Re: Were all in the wrong business.
    ... It's on the first floor. ... Get a PVC riser removal tool. ... May be too big for a seat, ... Found a remodel set for the PF three handle. ...
    (rec.boats)