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
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
@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
Answered here:
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |