I'm new with FileMaker and read some of the topics about filtering value lists etc.

But I'm having a parent-child problem with my program:

say I have a Category-table. I want to make a difference between a main category and a sub-category.

When I create a new category, i need to select if it is a subcategory or a main category.

In parentID I want a value list that displays only the category's that are marked 'main category'.

For example (screenshot):

The drop-down list should only display category's where CatType = mainCategory

It's probably pretty simple..

Edited April 4, 200718 yr by Guest

You can have a global field on your parent side that stores the word "mainCategory" and use that as a key to the child Category field.