Many-to-many or Table Occurrences
Hello, I'm confused about the usage of a join table.
|__pkCompaniesID (serial)||__fkCompaniesID (number)||__pkContactsID (serial)|
|company addresses||__fkContactsID (number)||contacts addresses|
In the layout companies I've created a portal to companies_contacts. When I verify the address information it is still correct. Now I wonder how I can add an existing contact in the portal. What do I need to do? I've looked at several examples, but it seems that a lot of them only use a table occurrence (also the starter solution Invoices in FM13). I think I've found a solution to add a new contact to the portal (thx to PhilModJunk), but not to add an existing one. As the last functionality is more common I would like to make it work.