Example: Adding a Computed Column
When viewing Scheduled Tours, front office staff should be able to assess available places immediately by comparing the capacity (total number of available places) and the number of places already booked.
The Scheduled Tours info window should have an extra query column showing the total number of participants already enrolled for that Scheduled Tour.
To add a computed column that shows the number of participants for that scheduled tour:
You will notice that USoft Developer automatically creates a new column in the info window to catch the results of the extra query.
FROM participant p, reservation r, schedtour s
WHERE s.schedtour_id = r.schedtour_id
AND r.res_id = p.res_id