how can i (many to many) dropdownlist refer

[esatkurtul1]

Hello every body

i have project which is ;

i created table like this, and i need to dropdownlist When I choose the company name, I want the list of employees affiliated with that company to come.

1) is that diagram true ?

2) how can i create dropdownlist as i said that ?

[Marc_Dillon]

You mentioned "many to many" in your post title. Is that the relationship between employees and companies? i.e., can an employee be part of multiple companies? If so, you need another association table for that.

[esatkurtul]

i have association table which is JOB (in picture)

when i put ;

SELECT( JOB[EMPLOYEE_ID] , [COMPANY_ID]=[_THISROW].[COMPANY_ID] )

(i am trying a new page page name is JOB)

when i choose company, it appears in employees who do not have a reference

[esatkurtul]

Yes employee work multiple companies and company has multiple employee

[Marc_Dillon]

You'd add the association table, then you could limit the dropdown choices with:

SELECT( new_table[employee] , [company]=[_THISROW].[company] )