I have a three tables with the follwoing charesterics 1. Some attributes are common on all table or in two tables. 2. Having common date filelds and some unique date fields. Im having difficulty in modeling how to combine the common fields.
I'm trying to achive 1. Avoid SYNC table and 2. Create a master calender combining all date fields (common or unique files) .
I have followed your model and i have question. In Table3, how do i connect Month field with the calender. Because i have provide a selection creteria for Month filed.
