Hi Knacksters,
a data table is connected with a child table “Audit trail” containing fields “Adress of change” and “Date of change”
- when i add a new record in data table, “Audit trail” gets its first record via record rules → Insert connected record of the web form. Here, both fields “Adress of change” and “Date of change” are filled with the current location resp. current date as expected.
The problems start when i edit an existing record of the data table.
-
When i use the record rules within the inline feature, the new record of “Audit trail” holds correctly “Date of change”, but “Adress of change” remains blank.
-
When i use a trigger to capture the current content of the data table into “Audit trail”, the new record of “Audit trail” holds correctly “Date of change”, but “Adress of change” remains blank.
The result of 2. and 3. is very much the same.
Does anybody know why i can capture “Date of change” in all three ways correctly, while “Adress of change” works only with the record rule of the web form in 1.?