8 Replies Latest reply on Feb 14, 2016 4:16 PM by user19752

    How to use summary field in calculation on a different layout?


      Hi All:


      I thought I posted this before 9:00 this morning, but it doesn't seem to have shown up. If I have double posted, my apologies.


      Work progresses on my conference database solution. I have a layout for conference sessions that looks like this:



      and like this:



      The Status field gets updated (and conditionally formatted) based on a calculation subtracting AvailableSpaces from MaxSpace, the limit for the session. It works well when I update the AvailableSpaces manually.


      What I want to do, though is have the AvailableSpaces update by looking at the summary field in a second table. This table is loaded from time to time with the registration data provided to us from our online registration service. The table looks like this:



      SessionTotals is a summary field that counts how many registrations there are for a session (once I sort on the SessionIDfk).


      I can't figure out how to take the total number of registrations for each session and have it appear on the correct record for that session on the Sessions layout.


      Am I going about this intelligently? Is there a better or more elegant solution?


      Thanks for your help.