I have a need to have multiple records use effective dated logic in a parent-child relationship. Consider the following:
Parent Record:
EMPLID (Key)
EFFDT (Key)
ACTIVE_FLAG
Child Record1:
EMPLID (Key)
EFFDT (Key)
EMPLID2 (Key)
ASOFDATE (Key)
EFF_STATUS
Child Record2:
EMPLID (Key)
EFFDT (Key)
EMPLID2 (Key)
ASOFDATE (Key)
DEPTID (Key)
My page looks like this:
The Problem is this: I can insert rows at level 1 (note the scroll without a border), however, at level two (and three) I get an error that I must be in Correction Mode to change current or history records. I assume this is because I have ASOFDATE instead of EFFDT at level 2.
How can I fix this? Is there another field that will act as EFFDT? Can I clone EFFDT and get the desired functionality?