AnsweredAssumed Answered

Conditional Value List - Products by Category

Question asked by FeldyNYC on Aug 23, 2014
Latest reply on Aug 27, 2014 by FeldyNYC

Title

Conditional Value List - Products by Category

Post

     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? 

Screen_Shot_2014-08-23_at_6.43.42_AM.png

Outcomes