AnsweredAssumed Answered

Newbie - Setting up parent

Question asked by QuickRon on Apr 16, 2010


Newbie - Setting up parent & child categories


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.


Thank you.