Caculation based on a value list or total number of records
I have 2 somewhat similar questions. I'm working on a solution to track lodging for our group. I have set up 3 related tables - Lodging, Hotel Rooms and Occupant and using portals to display everything in one layout. In the Lodging table I have fields to track the total rooms, rooms occupied and rooms available.
Is it possible to have the total rooms field be auto calculated based on the total number of records from the Hotel Rooms table?
Some events require us to share rooms so in the Hotel Rooms table I have fields for the # of beds per room and a male/female value list if we are sharing. On the Lodging table I also have fields for for total number of beds by gender.
Is it possible to have the total beds fields be auto calculated based on the assigned value of male or female?