I have a vendors table which is M:M with a category table (one vendor can have many categories and vice versa). And, there is a VENDORS-CATEGORIES join table.
On a "Vendors" layout I have a portal where I can add multiple categories, as expected, for each vendor. Yet, as with portals, I have to manually add each row of the portal for each vendor. So, if a vendor has three categories (for example, electrical, mechanical, and other), I would have to manually create three portal rows. It all works OK, but ...
What I would much prefer is if I could have, say, a separate tab on the Vendor's layout where I could see ALL the categories possible and then click off the ones that apply to this vendor (say, with check boxes). Then, be able to go to the next Vendor and select the categories, again from the list of all possible categories, that apply to this vendor.
Without coding something custom with lots of scripts, I'm not sure how to do what I want.
Am I missing something that FM makes easy?
Thanks in advance,