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.
-
@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 -
There are other references too.. I just recall Andy“s..
-
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!
-
@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.