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