I am registering individuals for a youth camp. I have one layout where each camper is identified by a field that tells what church they are with. I have another layout that will show the total campers / workers from each church and the appropriate costs. I need to figure out a way to make the "total camper" value on the church layout form to be automatically updated when a new camper record is entered onto the camper registration layout - but only when the "church name" field are a match on both layouts .... help!

Hi ntym,

When you indicate your camper layout vs. your church layout, do you mean you have two different table occurrences?

but only when the "church name" field are a match on both layouts

Relate campers to churches on the church field. Then from your church TO, create two calculations:

cCountWorkers (calculation, number) with: Count(Campers::ChurchField)

cSumCosts (calculation, number) with: Sum(Campers::ChurchField)

These calculations will automatically be unstored because they reference related fields.

LaRetta

I am still somewhat at a loss - what if I atatch the file so you can look at the fields. In my file - the "church totals" layout is where I need all the totals to be represented. The first 2 layouts are where the information will come from. I want to enter information from camper and worker applications into the appropriate llayouts, respectively, then have these numbers (of campers and of workers) be represented on the "church total" page that corresponds to each camper and workers' church page. Does that make sense? Thanks for any help you can give.

I am still somewhat at a loss - what if I atatch the file so you can look at the fields. In my file - the "church totals" layout is where I need all the totals to be represented. The first 2 layouts are where the information will come from. I want to enter information from camper and worker applications into the appropriate llayouts, respectively, then have these numbers (of campers and of workers) be represented on the "church total" page that corresponds to each camper and workers' church page. Does that make sense? Thanks for any help you can give. Well, I guess I can't atatch the actual .fmy file, oh well.

You can zip or stuff your file to attach it here. Or you may email me.

I'm a bit pressed tonight finishing a project so I'm unsure how much time I can give to it. However, I have been, still will be many times and currently AM exactly where you are and somone from these Forums helped me (hundreds of times) so yes, I'd be happy to give it a go.