Inverse DatabaseJoin Element

Personally I would do this with List joins rather than a join element.

Create a bands_artists List (which will be a many-to-many junction table) from the standard 'default' list type...

id (internalid element, ie. created by default when you create the list)
date_time (you can delete or unpublish this if you want)
band_id (create a 'field' element, set to type INTEGER)
artist_id (create a 'field' element, set to type INTEGER)

Then in the Bands list, create a join from band.id to bands_artists.band_id, and in the Artists list as artists.id to bands_artists.artist_id. In both cases, set the join to Repeat.

You'll then have a new group on each form, for the repeat. In the Bands copy, you can hide the 'band_id' element, and change the artist_id element type to be a 'databasejoin' (as a single select dropdown) to artists (value 'id', label 'name'), and in the Artists copy hide the artist_id, and set band_id to be a join to bands.

That should then be naturally be an insverseOf. If you add an artist to a band, if you then view that artists form, the band will be listed.

You can set the 'layout' of the repeat groups to be 'table', which would probably be a better visual look.

It does mean that to add an artist to a band (or vice versa), you have to "Add" a new group, and then select the artist from the join dropdown, rather than just selecting them all from a single multiselect.

But on the other hand, it means you can do "other stuff" in the junction table, for example using an autofill plugin, or maybe CDD's, to fill other fields in the junction table (like 'instrument'), taken from the artists (or maybe an artists_instrument) table. Etc.

-- hugh