We're facing a problem working with portals. Here's an example:
We have a "Company" and "Employee" table. To keep an archive of the
companies of an employee, we have an intermediate table that has
IdCompany, IdEmployee and DateEnd fields. When "DateEnd" is empty, we
know that it's the active company for this employee.
What we want to do is to display a list of all employees for a
company. So that in the Company table, we have a portal related with
the intermediate table. The relation is done with calculation fields,
looking for matches of the company id, and ...