dmarlowe

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 in within a single form. Ideally, it would be great to have a list of checkboxes where I could check which categories the business should be included in and it would submit the appropriate category IDs to the associated table. Is there any way to do this?