10 Replies Latest reply on Apr 28, 2016 2:02 PM by joecc

    Linking 2 artists with 1 painting

    joecc

      I have an art museum database with a table of artists linked to a table of artworks. Until now, all works of art in db had only 1 artist associated. I guess I need to create a 2nd occurrence of artists table & successfully link them to 1 piece of art. I could also revise my artwork layout to include 2 fields for artist(s). Right?

      Next I need to figure out how to create a printed report. Right now, I would like to hear form someone to say whether the plan above is the right approach. Once I cross that hurdle, I'll deal with the report issue.

      Thanks for any ideas.

      Joe CC