Let's say I have a modified EMP table:
create table emp(
empno number(4,0),
ename varchar2(10),
job varchar2(9),
partnerno number(4,0),
constraint pk_emp primary key (empno),
constraint fk_emp foreign key (partnerno ) references emp(empno)
)
This is exposed in an interactive grid. As you see there is a foreign key to the table itself for the column partnerno, which is, sort of, the partner to the employee. When working with the employees in the interactive grid I want a LOV to select the partner:
- The LOV should not show the employee on the same row. (An employee can't be a partner of himself).
- The LOV should not show employees that already are registered as a partner (one employee can have one and only one partner).
- The LOV should show the partner name in the interactive grid (when not in edit mode for example)
Suggestions to solve this?