I have a table of businesses with all of their information. I need to allow each business to have multiple categories and each category to contain multiple businesses. I understand this is a many to many relationship and have found multiple topics in this forum that explain the table relationships and implementation. What I can't seem to find is an easy way to add/update entries in this setup. I would like to have the ability to add or update a business and select which categories it should be i
I am having problems with this many-to-many area as well. The tutorial mentioned here and the documentation don't address it.
Yes you can create a joining table to form the many to many relationships. But all sorts of problems arise, and I haven't as of yet found any solutions.
The main problem arises from the fact that a Caspio form (or "datapage") is tied to only 1 specific table or view. And therefore if you're searching based on a many-to-many relationship, your search