AnsweredAssumed Answered

Conditional Value List - Products by Category

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


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?