Forum Discussion
Data Model Feedback
CB13 ,
I'm afraid in the current data model, you can't achieve this goal. The only way is as you said, to create 3 copies of owner table and build relationship between those copy table and Visit, Test and Item table.
Regards,
Jimmy Tao
Hi,
The final example is what I am currently using - but it doesn't allow me to link on Owner ID directly to the Visit and Test tables. Since the owner's vary this is important:
It feels like I may have to create 3 "copies" of the owner table, 1 to join to each, but this feels wasteful, especially since this is a simplified example and in reality I will likely have several more tables that need this same information.
I'm not sure what you mean by join the tables together in the data model. Wouldn't this then create a lot of additional data fields with repeated data - meaning that all of the Visit data would be repeated at the Item level, over and over again? This also feels ineffecient?
CB13 ,
I'm afraid in the current data model, you can't achieve this goal. The only way is as you said, to create 3 copies of owner table and build relationship between those copy table and Visit, Test and Item table.
Regards,
Jimmy Tao