Summary fields in portal
I am new to using FileMaker. I have a database that has a portal showing a job log. In this job log there needs to be summary fields to track the type of hours worked. I am having trouble figuring out how to make the calculation based on the type (from pull down menu) work. Do I need more fields for each type or can the calc differentiate each type then do the hour summary?
Below are the fields:
Parent db - field - employee #
related db - fields - employee #, hours, type of hours (pull down), summary of hours based on type
Thank you for your help in advance.