help with relationship

[DavidiHd]

hi everyone

i am trying to built a dashboard that will show a budget allocation vs budget utilization

i have some tables involved:

CUSTOMERS,BUDGET UTILIZATION -SQL , BUDGET ALLOCATION - EXCEL ,DATE-YEAR ,BUDGET-SQL

I HAVE ACTIVATE RELATIONSHIP BETWEEN

1.CUSTOMERS - ,BUDGET UTILIZATION -SQL

2.CUSTOMERS -  BUDGET ALLOCATION - EXCEL

3.BUDGET-SQL - BUDGET UTILIZATION -SQL

4.BUDGET UTILIZATION -SQL - MONTH-YEAR

BUDGET ALLOCATION - EXCEL - MONTH-YEAR

I AM TRYING TO ADD RELATIONSHIP BETWEEN BUDGET ALLOCATION - EXCEL AND BUDGET-SQL

AND GETTING "AMBIGUITY BETWEEN TABLES OR SOMTHING"

i am put here the table diagram and relationship - the bluw arrows are active ones

and i need to find a solution to activate the orange arrow or to find a way to sync between the budget-sql slycer and the BUDGET ALLOCATION - EXCEL > budgetname slycer

[amitchandak]

@DavidiHd , Make sure from Customer, Month and Budgets-Sql, the otehr two table are in 1 to many relationships and that to one directional. that should solve the purpose.