Conditional Value List - Products by Category
I have a LineItems Table an Artwork Table and an Artists Table and I am having trouble finding the connection in the LineItems Table once I bring in the artist to finding the titles under that name.
Line_Items---Artwork Table --- Artists Table.
First I populate the Artwork table with artist and a title - In the Artwork Table I have Artist_ID_FK
In the LineItems Table, I have Artist_ID_FK and I have I have an Artwork_ID_FK where I would like to see the title.
Is this right?