Dependent dropdownlist many to many relationship

[TechnoHello]

hello mate i have a project for my job but i did not answer it

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

i have 5 table which is

1)employee

      a)employee_id

      b)employee_name

      c)employee_surname

2)company

      a)company_id

      b)company_name

3)connection

      a)connection_id

      b)employee

      c)company

4)query-company

      a)query_company_id

      b)query_employee

      c)query_company

5)query-employee

      a)query_company_id

      b)query_employee

      c)query_company

 connection table  (company)  > reference > company table

connection table  (employee)  > reference > employee table

query-company table (query_company) >reference > company table

query-employee table (query_employee) >reference > employee table

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

(in  query-employee table)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. Should i create any concatenate in any table

[Marc_Dillon]

---

@TechnoHello wrote:

how should i set up the dropdown list

---

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

---

@TechnoHello wrote:

and how can i set up KEY and LABEL in all table. Should i create any concatenate in any table

---

Each table needs a unique key value. 99% of the time, you should use UNIQUEID(). https://help.appsheet.com/en/articles/1023086-what-is-a-key 

As for the label, that's up to you. https://help.appsheet.com/en/articles/961466-row-labels 

[Steve]

Answered here:

Re: dropdown list depentdent - Google Cloud Community