Synthetic Key Problem

[#1]

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.

[luciancotea · Accepted solution]

Concatenate the tables:

LOAD * FROM table1;

concatenate LOAD * FROM table2;

[khadeer]

Hi,

There is no need to give association . Just you have to concatenate both tables.

Regards,

Khadeer