I am building a custom events system. In this part, the main table being viewed and edited will be "events". Part of event editing needs users to know how many participants are registered for the event. THat information is in a participants query. Is there a way to have read-only data displayed from other tables / queries. The common field between the events and the participants is the event name. Here is an example of some fields in the edit form.
Event name (from Events table)
Event location (from Events table)
Event start date / time (from Events table)
Event end date / time (from Events table)
Number of participants (read-only from participants query)