AnsweredAssumed Answered

Newbie - Setting up parent

Question asked by QuickRon on Apr 16, 2010

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

 

Outcomes