Hi All.

I have following idea and want to know whether it is possible at all with the Form and List module or if it is only possible with a custom module.

Let's say i have two tables:
Table A holds all Department names of my company including costcenter-codes
Table B holds all employees of my company

What i would need is the relation between these two F+L modules, better the data behind it, as each emloyee has one relation to "his" department.

So when browsing to one specific department in the first module, the second module on the same page should only show the employees of this department.

In SQL this would be something like: select * from employees where department_id = xyz

Any idea?

Thanks in advance

Kai

  While Sebastian is correct that FnL doesn't support relations, you would be still able to solve this task also with FnL.FnL cannot support the relation during edit.