AnsweredAssumed Answered

Linking 2 artists with 1 painting

Question asked by joecc on Nov 7, 2015
Latest reply on Apr 28, 2016 by 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