portals and related records
Ok, I'm new to FM and database applications so please bear with me. I am working on a database for tracking projects at work. I have a layout called "Project Details" which has a portal with various tables. one of the portal tables is called "Proposals" and there is a popover that has fields for applying payments for the "Proposals" table. The problem I'm having is the sum field is adding up the total for ALL proposals combined and listing the payments on ALL of the proposals rather than EACH INDIVIDUAL proposal. I did not use global variables. Just trying to describe it confuses the heck out of me. I'm stuck on this one part and its driving me nuts. Please help. Thank you very much.