Calculate value from multiple table entries

Hi there,

Any hints on how I can best do this… I have a system where you can add accommodation. This accommodation can have a number of rooms that are added. The rooms have a maximum number of guests and there can be more than 1 of this room. For example:

Room 1 - qty: 3 - number of guest: 2
Room 2 - qty 4: - number of guests 3

What I want to do is store the total number of guests that this accommodation can handle. In the above example, this would 18.

How can I iterate over all the room records and do this calculation?



Thanks Nigel. I had seen that option, but wasn’t exactly sure how it would work. I went down a slightly different path but achieved what I needed. Will keep this in mind for next time though. :slight_smile:

This topic was automatically closed after 70 days. New replies are no longer allowed.