I can't make out your current relationships in the first screen shot and thus can't tell what match fields match to which. If you were to drag the occurrence boxes a bit further apart so that the = operator doesn't obscure key details, I could more clearly see what you have currently in place.
What does one record in line items represent? The sale of one copy of a record in Artworks? (such as selling a print....?)
And do you want to select an artist first, then see only the artworks linked to that artist? Or is there some other Category (genre?) involved?
I will assume that you want to select an artist and then select from the artists works in this example.
That would require these relationships:
ArtworksByArtist>-----Line_Items>---Artwork_Table> --- Artist_Table
Line_Items::_fkArtistID = ArtworksByArtis::_fkArtistID
Line_Items::_fkArtworkID = Artwork_Table::__pkArtworkID
Your conditional value list would list values from ArtworksByArtist, __pkArworkID for field 1, a name/description field for field 2. And you'd format the Line_Items::_fkArtworkID field with this value list. In the value list setup, you'd select "include only related values, starting from line_items".)
I've just released Adventures In FileMaking #1, a training resource on Conditional Value Lists that demonstrates 8 different variations of a conditional value list in one file. You can down load it from my FaceBook page.
i had been frustrated for months and this worked perfectly, thank you! I will be sure to look at your caulkins consulting, home of adventures in filemaking.
Once again, thank you.