Forum Discussion

CB13's avatar
CB13
Frequent Visitor
6 years ago
Solved

Data Model Feedback

Hi, I am sketching out my pass at a data model and have a question for the hive as I am relatively new to trying to figure out schemas, and I think my data is a bit of mix with transactions that hav...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Hello CB13 

Assuming that the owner of the test is the same as the owner of the visit that the test was performed on then you only need to go from Owner > Visit, Visit > Test and Test > Item.  Filtering an owner will flow down the relationship through visit, test and item so you don't need to link the owners to all three tables, just the hightest one in the chain.