Hello, lets say I have two tables: "orderDetails" and "Orders". Table "Orders" has fields "date_added" and "user_added" which are set as "CurrentDateTime()" and "CurrentUserID()" in "Auto-Update Value" of table settings. If I add record to table "Orders" then "date_added" and "user_added" are automatically inserted.
Table "orderDetail" has field "orderId" and "Allow add" option (all fields of table "orders" selected).
The problem is that "Allow add" option inserts information to table "orders" except Auto-Updatable fields "date_added" and "user_added" - leaves empty.
Please advise how to solve. (v2024.8)