Unless all artworks are solo pieces, you will need a third table so that an artist can be linked to many artworks and an artwork can be linked to more than one artist. But that's all a different issue.
If you have this relationship:
with a portal to table B placed on a layout based on TableA, You can put a button inside the portal row or use button setup to turn the fields in the portal row into a button. This button can use Go To Related Records to pull up this record on a Layout based on TableB.
That sounds exactly what I need. The art pieces are related to only one artist in any case. I haven't seen anything like 'button' so will have to take a closer look. Is it simply called a button or something else?
There is a button tool in the status area tool bar when you are in layout mode. You can click it then draw a rectangle on your layout to create a button. There is a button setup menu option in the format menu. While in layout mode, you can select an existing layout object and select this option to turn the layout object into a button.