0 Replies Latest reply on Apr 16, 2010 10:54 AM by QuickRon

    Newbie - Setting up parent



      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.