Show related found results in a tab panel?

Classic Servoy
1

Hi All,

I am new to Servoy (although experienced in FileMaker), and am trying to do something that may well be too advanced for me now.

On a form (table A), I have a tab panel showing all related records from table 6. I want to be able to perform a search on the records in table b and show only those found in the tab panel on the form.

Am I flying too high too fast?

Thanks

2

A relationship is just an easy way to tell Servoy to load in a set of records in your tab panel when a record is selected.

In FileMaker, to filter a related foundset you add globals to the left hand side of a relationship. A user puts a value into a global to get a relevant record set returned.

Unlike FileMaker, Servoy has events at runtime. One of those events is onRecordSelection. You can use this and other events to manage your related list of records without using a relationship. This gives you the flexibility to add whatever find mechanism inside the tab panel that you want.

To set up a “related” tab panel without using a relationship:

  1. In the tab panel, point to the form (table b) via “unrelated”
  2. Form a > onRecordSelection: create a method that loads in the correct related records. Something along the lines of:

forms.formB.controller.find()
forms.formB.fk_tableA = pk_tableA
forms.formB.controller.search()

This gives you a starting point of “related” records that you can apply addition searches to. Attached example uses a header search.

Picture 49.png
Picture 49.png788×361 60.6 KB

3

David,

Wonderful - that’s really simple!

I really appreciate your help

Tim