How to organize the dependency between tables?

[11146]

My tables and columns:

• tasks
  — title (text)
  — manager (ref managers)
  — collaborators (how to attach one or more subordinate manager???)

• employers
  — email (email)

• managers
  — manager (ref employers)
  — subordinates (ref employers, how to tie a lot of employees???)

Please help me with the columns: “collaborators”, “subordinates”. What type should they be? What formulas should be used in them?

[Aleksi]

The best option would be Ref fields and then no formulas are needed.

Please check this article…

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so that your data makes sense.

[11146]

But how to make a field where you can select multiple rows from a linked table?

[Steve · Accepted solution]

Column type of EnumList with base type of Ref.

[11146]

I set up https://www.screencast.com/t/dy1vD3pZ

But there is nothing in the drop-down list https://www.screencast.com/t/htAaaGmWlYjj

What am I doing wrong?

[11146]

I solved this problem, thanks for the direction!

[11146]

Could you send an example application where there is such a connection? I can not understand what is the basic type.