I my other post I was having problems getting a handle what was going wrong until I went into diagram view today to notice the relationships I had made, never became active.
http://www.mrexcel.com/forum/powerp...working-will-not-filter-date-dim-account.html
No warning message or anything, I was reordering data that wasn't even tied together.
But back to the new concern.
I have an existing table I would like to connect to my two new tables.
The first table is related to Date and Employees.
If I try to join this table to Accounts Unique (New table) it will not allow it.
I am not doing anything complicated I thought, I just need to create a matrix style report for 2 different types of account activities which I have to find by a concatenated field.
Is there anyway to do this or help me understand or is two relationships/tables just the max.
I do notice my other 15 tables only have two rels. thanks
http://www.mrexcel.com/forum/powerp...working-will-not-filter-date-dim-account.html
No warning message or anything, I was reordering data that wasn't even tied together.
But back to the new concern.
I have an existing table I would like to connect to my two new tables.
The first table is related to Date and Employees.
If I try to join this table to Accounts Unique (New table) it will not allow it.
I am not doing anything complicated I thought, I just need to create a matrix style report for 2 different types of account activities which I have to find by a concatenated field.
Is there anyway to do this or help me understand or is two relationships/tables just the max.
I do notice my other 15 tables only have two rels. thanks