With Formidable Pro, data from two records from two forms can be combined on one view.
To pass a variable from one "view" to another, embed in the "parent" view:
[display-frm-data id=child-view linked_value=[id_or_key] filter=1]
In the view name "child-view" Advanced Settings / Filter Entries:
select {linked field} is "equal to" and enter "[get param=linked_value]"
From https://formidablepro.com/help-desk/link-data-from-two-forms/
[display-frm-data id=2 user_id=[25]]
Parent info here
Replace [25] with the ID of your user ID field
Change 2 the the ID of your student custom display
the display name is used by default with [25] (the user ID field or [nqbfr7] in your display). I added show=id so the user ID will be used so there is no room for error in what entries are linked to which users.
[display-frm-data id=9 user_id=[nqbfr7 show=id]]
View "id=9" has it own logic for what is displayed.
From https://formidablepro.com/help-desk/relational-databases/
You could use the artist form to create one custom display set to show all entries with a link to view the paintings (a second custom display). The link would look something like this:
Site.com/page-with-display-2?artist=[id]
Then the second custom display would be set up using the paintings form. You would add a row in the advanced settings section for the artist data from entries field equal to [get param=artist]