Qrew Legendno problem,
Let's deal with Clients first.
You will need a relationship for one client has many Jobs to select the Requesting Client. Rename the Related field to be called [Related Requesting Client]. Lookup the client name and call it [Requesting Client Name].
Set the Proxy field to be Requesting Client Name by editing the field for [Related Requesting Client] and setting the Proxy. Proxy field is the one that you will use on all forms and reports.
Did that process two more times for the other two client fields. If you copy the field [Related Requesting Client] not only will you get that field but you will get the relationship created again as well.
Sure all of your fields have appropriate names so you don't get confused between your three set of Client Relationships and their field names.
You have a Jobs table now, so the next table that you need is Job Artwork Lines. Make a Relationship where one Job has many Job Artwork Lines. The Job Artwork lines table is where you are going to identify the pieces of art to be moved.
Now, it's not clear from your post of you intend to have a master table of Artworks where you would list the Artworks. Perhaps you are an Art Rental company and the inventory is moved around as your clients get bored of looking at the Mona Lisa all day (same old - same old) and decide to with her out for "Persistence of Time and Memory by Dali.
But if you will have that Master Art SKU table, then One Artwork will have many Job Artwork Lines.
The locations of the Artwork at any time can be known. If you do a lookup of the Job Movement date from the Jobs table down to Job Artwork Lines, then each line knows when it was moved. You can do a Summary maximum of the date up to Artworks to know when it was last moved subject to the filter that the date is not in the future. Then do a Combined Text Summary field for say the Delivery Client and that is where the Artwork is now .
