AnsweredAssumed Answered

Related tables question?

Question asked by egarcia8 on Apr 18, 2018
Latest reply on Apr 24, 2018 by egarcia8

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?