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.