CODEWITHSUNDEEP
filemaker
Tom
Tom

Reputation: 2873

Filemaker: How to fetch list of related entities

I'm new to Filemaker, but have extensive SQL experience.

How do I add a list of children to my Filemaker layout, if I have a one-to-many relationship (a tree)? I would like to see for my current node all its children. Later I want to filter them as well.

Showing the parent is easy via the related field. But for the reverse it appears that I need to use scripts?

In SQL, I would write:

SELECT * from Element WHERE parent = {current_id};

Upvotes: 0

Views: 92

Answers (1)

AndreasT
AndreasT

Reputation: 2337

You set up a relationship between the tables in the relationship graph using a primary key and foreign key arrangement. Then you add a portal to the related table occurrence on your main table layout. You can add filtering in the relationship itself or in the portal afterwards.

I advice you to check out this info from FileMaker on the subject.

Upvotes: 1

Related Questions