Let's say I have 'Events' and 'Bands' lists, relation is many to many, so I created the Events_Bands list and when you edit the Events list you can choose which Bands are playing by choosing their names from the drop down together with the date, so they are placed in a repeatable group so you can add as many bands as you want. And that is all working fine. However on the 'Bands' form I want only to display a 'read-only' Events listing that this particular band is assigned to, without a drop down to assign events here.
I tried calc something like this:
$data = '{events_bands___event_id}'
echo '<pre>';print_r($data);echo '</pre>';exit;
or:
return (int)'{events_bands___event_id _raw}';
But the first one returns nothing, and the second one returns zero.
I'm not sure if the calc, display or text fields will actually work to display related data? If not what else can I use to display list of assigned events on band profile?