Calculation field help

[luiscovar]

Hello, I need some help on making a form like this one http://i.imgur.com/wCpcHmc.png?1. I have a database which includes the names and addresses of all the people in my community. I have a separate table just for this form and is linked to the "contacts" table by their address.

Each record in the neighborhood watch table has the address of each house. Which then shows the name of the people living there by using a portal. However, here is my problem. The form has two separate fields for Adults and Children. Each person has their own record but is not organized well because not everyone wanted to include their age. So they were given these options:

Infant/Toddler

PreK-Grade 2

Grade 3-7

Adolescent

Adult

Senior Citizen

Special Needs

What kind of fields would I have to make to separate the Adults and Children? We can assume that Adult and Senior Citizen are adults. Anything that isn't that is not. So I think I can use some if/else calculations but I'm still not sure. Any help would be appreciated.

[eos]

It''s usually best to organize and structure your solution properly, then let your data “take care of itself”.

 

See here:

FamilyAgeGroups_eos.fmp12.zip

[Lee Smith]

Hi Luis, and welcome to the FM Forums,

 

I moved your topic from "FileMaker Pro 12" to "Calculation Engine (Define Fields)” because, the General Topics are for discussion of the Tools, Functions and Features that were introduced with the release of FileMaker.

 

This topic seems to fit your request.

 

Lee

[luiscovar]

Thank you Lee.

 

I agree eos but I did not create this database from scratch but am helping a friend out with his task. However, I'm still pretty new to filemaker. What I'm confused about is how you managed to create the list in the portal without having to have a field for each option? I'm sure it's an easy answer but I still don't see it.

 

What would be the best way to create it with working on what I have?

[eos]

What I'm confused about is how you managed to create the list in the portal without having to have a field for each option?

 

There's one record for each option.

 

What would be the best way to create it with working on what I have?

 

Same principle, just that now you add people instead of groups. Then count the people by group association, instead of summing the values per group.

 

Try the attached file. There's an SQL approach added.

FamilyAgeGroups_eos_v2.fmp12.zip