I am appending these 2 tables so that the Daily Table looks like:
Date PERNR Region
1/17/2018 1 X
12/31/2018 1 X
But when I load this table to the front end, it throws the following error
I dont understand why this is causing a problem as I have similar projects in the same pattern (That is multiple PERNR Records and same type of relation between the tables) but it has not thrown this error. Any suggestions?
Looks like your daily table is at the "One" end of One to Many relationship in your model. So, when you append rows to the daily table , which makes the joining column duplicated values, which means the relation is no more "Many to One", hence the existing relationship fails. This append makes the relationship as Many to Many , which needs to be elminated by introducing a relationship/ bridge table.