I have a database composed of multiple projects. Each project has a number of objects attached to it (models, drawings, photographs). These objects appear in exhibitions, often more than one.
I am trying to come up with a table that would display all the objects that belong to a particular exhibition. Here is what I have tried:
I created a new occurrence of the table that contains all of my objects. In this table I connected the __kp_ModelID to the Exhibition table's _kf_ModelID. I also connected the _kf_ExhibitionID in the objects table to the __kp_Exhibition ID in the exhibition table.
I think that part of the issue is the fact that each object belongs to multiple exhibitions, and is thus trying to store multiple _kf_ExhibtionIDs.
Any idea how to work around this issue?