HI Onno and Chan ,
Thank you for your advise .
My biggest problem is I cant seem to wrap my head around using the unique" identifiers "
I have 3 sets of data - Quotes , Sales and back orders .
There is 5 of the SAME fields that I need to use to help with my visualization
Customer name , customer type , product code , product description and rep and this will always be there and also constantly change
If I generate this I get synthetic keys but my data loads properly ( I know that it is not great to have syn keys ) but it works .
The problem comes in when loading different days data - eg data was loaded from 1 June - 29 June and the app works great but as soon as I import my data for 30 June I get the load data error and none of my data gets updated
Will adding the master calendar make any difference ??
Thank you again !!!