So we decided to bite the bullet and jump ship from Access to Filemaker. It seems like a wonderful tool but we are struggling since we have developed for years in Access!
We want to create a function that will sum values of a particular table based on the current ID of a record we are on? We have added a portal to show the child records but are having a heckuva time figuring out a way to display a summary of the dollar amounts in the portal. In Access we had a DSUM function that we could just assign to the field. Anyway... enought about Access. We have created a Summary field and it works BUT only when it is embedded in the portal. We want to display the summary below the portal.
Hopefully I haven't insulted this forum. Any help would be greatly appreciated!