Display connected Formdata

[Markus Hintzsche]

He there,

given the fact I've got two forms:

formDepartments with field "name"

formTeams with field "name" and department as a smart classifier to select the department, the team is in.

How to display all teams, that are connected to a specific department on formDepartment? On SQL it would be an INNER JOIN... How to achieve this in confiforms?

Kind regards,

Markus

[Mercy]

In ConfiForms, you don’t use SQL joins, but you can achieve the same result with field references and filters between your forms. If your formTeams has a smart classifier field pointing to formDepartments, you can show all linked teams in formDepartments using a ConfiForms TableView or ListView macro configured with a filtered dataset. Inside the macro, set the Form definition name to formTeams and the Filter to something like `department:[entry.name]`, where `entry.name` refers to the current department record. This tells ConfiForms to show only those team entries whose “department” value matches the current department form entry.