Section Access_Data Modelling

[marishnagendran]

Dear All,

Reduction Table		Site_Master		Fact_Table
Branch_Name		Site_ID		Site_ID
SA_Section		Branch_Name		Cust_ID
				Emp_ID
				Qty
				Value
Executive
Emp_ID
Branch_Name_Executive

Above is my data model

I have used one reduction table based on Branch Name.

Same branch name column is referred in 2 tables (Site_Master, Executive)

In Executive table i have changed name as Branch_Name_executive to avoid synthetic key

My Reduction table works fine

But When i used Branch_Name_executive column in front-end the column shows NULL

I don't know why. Need your Help