I'm new to FileMaker and working on creating a Product database. I'd like to set up categories for the products, where there is a "main" category (ie. parent) and then sub-categories (ie. child) for each main category.
In addition, a product can be assigned to more than one main category AND to more than one sub-category.
I'm stumped on how to create the tables and relationships for the categories to achieve this. Right now, I have the "product" table and Product_ID as the primary key. Any help would be greatly appreciated.