0

many to many link

Hi there I have 2 tables and when I link 1row from the table that row is not available to relink any solution to help me fix this?

 

Table 1 = Company

Table 2 = Client

 

Now each company has multiple owners, managers, and employees but when I link 1 company to one contact it is not available to link with another employee. How do you solve this problem I am sure many people using this sort of link looking forward to your kind reply thanks in advance stay safe.

4 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Inder k

    You need to create an associative table between.   Generally .. call it  the two table names combined...  Like Company Clients ... 

    Our good friend Andy over at Nioxus has a short video on this..

    https://www.youtube.com/watch?v=SmbtXjmsi_o

    • Mconneen
    • 4 yrs ago
    • Reported - view

    There are other references too.. I just recall Andy“s..

    • inder_k
    • 4 yrs ago
    • Reported - view

    Thank you @Mconneen I didn“t know all these videos exist as I only have seen videos on ninox youtube channel.

    Thanks again I do have a much better understanding now of how to do it thanks for your time and quick help cheers!

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @inder k

    There are several Ninox partners that have good documentation / blogs .. etc...  The Youtube items are by far the best.

     

    Good luck!   Any more questions?   Start a new thread.. Lots of good folks out here to help.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 462Views