Referencing an unbound form control in a continuous form using recordsetclone (1 Viewer)

[dobseh]

I am not sure if that can be done resulting in an editable form. That query will likely require and aggregate query or a subquery to get the three denormalized columns, making the recordset read only. If read only is fine, then simply do this in a report with Grouping. Then you can show the linked swimmers under the contact and only show the correct amount of contacts. But I do not know much. I would likely consider a temp table or disconnected ADO recordset, but that could require some code to push updates.

It doesn't need to be editable, fortunately, there is an Edit button for each record on the form which opens a modal popup form that has all of the details of the contact on. I know they aren't, but temp tables always feels a bit like cheating to me.