dropdown list depentdent

[esatkurtul]

HELLO 

i need to help for my project.

 connection [company] reference > company table

connection [employee]reference > employee table

query[company]reference > company table

query[employee]reference> employee table

a company can have multiple employees,  An employee can work more than one company.>>(many to many relationship)

how should i set up the dropdown list in query employee table (when i select company, the employees affiliated with that company are listed

how should i set up the dropdown lilst in query company table (when i select the employees, i want to see in which companies he/she works.

and how can i set up KEY and LABEL in all table

[esatkurtul]

anyone help please

[Steve]

---

@esatkurtul wrote:

how should i set up the dropdown list in query employee table (when i select company, the employees affiliated with that company are listed

---

SELECT(
  Connection[Employee],
  ([_THISROW].[Company] = [Company]),
  TRUE
)

---

@esatkurtul wrote:

how should i set up the dropdown lilst in query company table (when i select the employees, i want to see in which companies he/she works.

---

SELECT(
  Connection[Company],
  ([_THISROW].[Employee] = [Employee]),
  TRUE
)

---

@esatkurtul wrote:

and how can i set up KEY and LABEL in all table

---

In Company, set the label to Company_Name.

In Employee, set the label to Employee_Name.

In Query_Company, set the label to Company. Set the Company column type to Ref to the Company table.

in Query_Employee, set the label to Employee. Set the Employee column type to Ref to the Employee table.