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

    Newbie - Setting up parent

    QuickRon

      Title

      Newbie - Setting up parent & child categories

      Post

      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.

      Ron