How to organize the dependency between tables?

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?

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

Please check this article…

2 Likes

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

Column type of EnumList with base type of Ref.

1 Like

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

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?

I solved this problem, thanks for the direction!

1 Like