Self-referencing foreign keys

[markfoerstein]

I used the CRUD generator to create an app based on the Employees table provided by Oracle. After a few adjustments, I got it working pretty nice.

This table has a foreign key (manager_id) that references the primary key of the same table (employee_id). That is, an employee can manage many employees (one-to-many) and this very same employee can be managed by another employee (many-to-one).

In the application, I can successfully:
- Search for existing employees.
- Create/Update/Delete employees.
- Select a manager for an existing employee or when creating a new employee.

The problem I will describe could be easily solved by getting rid of the "View Manager", "View Employee" and "Create Employee" buttons shown in the figure. But I would like to know if there is a possible solution.

http://images.tigratuning.com.br/misc/seamapp.jpg

When I click one of these buttons, essentially what happens on all of them is that I need to get a new editor for a employee different than the one I'm currently editing.

I can't use the same employeeEditor, because I will certainly get a concurrent call exception.

There's no way to create editors for the manager or managed employee, since, well, you can imagine where this would take us... an endless mess.

Is there a way out of this? Any possible solution?

Thanks in advance.

[markfoerstein]

Sorry for flooding the forum reactivating this topic, but I really wanted to know if anyone has a clue on how I could make this work.

Thanks folks.

[markfoerstein]

Last attempt. Anyone? ;)

[maxandersen]

the seam templates doesn't handle self referencing tables. They need to be fixed.

[gavin.king]

I guess no-one really understands your description of the problem.

[markfoerstein]

Thanks anyway.

Max probably got my idea. The seam templates doesn't handle self referencing tables. I though I could solve this problem by doing some changes to the code, but my expertise is limited. ;-)

I will save this example I did for later, and go on learning other Seam aspects...