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.
Like Follow
4replies
-
@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