Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relationship issue

Hi Fellow modelers,   I need help with a scenario. I understand the conceptual difference between one-many / many-many relationships and the nuances of many-many. I have a situation where i am usin...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Make one of the columns as aggregated like first/last min/max

 

Ideally, speaking you should analyze table and table 2 along with table 3 only

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak I understand and i could use another column or pull in same CIM ID column as scalar and it would work. But i can't tell end users (more than 500 and keep on adding) to do it in a specific way. Their requirement is pretty straightforward : "Provide CIM IDs for each Companies referred in file". So they send in a file with IDs  and they keep sending request with sasme issue and i tell them to pull in a scalar value to get the required details but i need to find a better way to cope with this issue.