Hi there ,
i have a question. I have created a Master Calendar and also composite keys and link table as well. My last thinking is, Should a Master Calendar link to a Link Table as well? or just leave it out from a link table?
A Master Calendar should link to a date field. I don't know if that date field is part of of link table. Perhaps this blog post helps: Canonical Date
Hi there, yup, i have linked it to a date field. but is it neccessary to create a composite key in the master calendar table, then link it to a link table?
Its up to you
for better performance and clear view create composite key in mater calender as well.
ok thank you
Retrieving data ...