I am creating a db for a boarding/kennel facility which involves 3 files. The three files are related and share the relationship field of

Hi FMNovice12,

Try: Sum(PetInfo::WalksPerDay ) * 2

This will give you the total fee per client. If you want to maintain the fee per dog, put it in PetInfo as: WalksPerDay * (your fee) and then use Sum(WalksPerDay) in your main file for the total customer charge.

I wouldn't hard code the fee into the calculations however. You could even use a global in your main file called WalkFee and reference that in your calculation. This will make it easier to change if need be (but it certainly isn't necessary).

LaRetta