Hi,
I am using LEI 6.x with Domino R6.5 and DB2
In DB2 I have 2 tables:
EMPLOYEE TABLE, with the following columns:
Emp_ID (PK)
Emp_Name
Team_ID (FK from the Team table, can be null)
TEAM TABLE, with the following columns:
Team_ID (PK)
Team_Name
In Notes I have a form EMPLOYEE with the fields:
EmpName
EmpID
TeamID
I have set up Virtual Fields Activities to monitor the Notes form, etc.
From the tables above you can see that an EMPLOYEE is linked to a TEAM via the Team_ID. I want to be able allow users to save the EMPLOYEE record and so that when the TeamID field is empty LEI will set Team_ID to NULL in the EMPLOYEE table. How can I do this?