Hello Community,
I'm having trouble with synthetic keys. I've gone through several posts but I can't get my scenario to work.
I have two tables which both have the following columns: Month, Year, Date and Department. The rest of the columns has no connection between the two tables. I also have a category column to let me distinguish between both tables.
So each table will get its own sheet but since I want to use those 4 columns as selection and listboxes and also add a Dashboard where both tables are shown I need a way to remove the synthetic key that is being created.
What are my options here?
I'm guessing I can combine Category+Department+Date to get a unique KEY. But how do I continue from there? I also want to use a Master Calendar table.
TABLE ONE:
Category | Department | Year | Month | Date | Independent Col |
|---|
| ONE | A | 2012 | 1 | 2012-1-1 | |
| ONE | A | 2013 | 2 | 2013-2-1 | |
| ONE | B | 2012 | 1 | 2012-1-1 | |
| ONE | B | 2013 | 2 | 2013-2-1 | |
TABLE TWO:
Category | Department | Year | Month | Date | Independent Col |
|---|
| TWO | A | 2012 | 1 | 2012-1-1 | |
| TWO | A | 2013 | 2 | 2013-2-1 | |
| TWO | B | 2012 | 1 | 2012-1-1 | |
| TWO | B | 2013 | 2 | 2013-2-1 | |
Thank you.
