Creating related records
My main table is from an External Data Source so avoiding the creation of additional fields there.
So I created a related table by "Date Entered" and have added a "Machine Age" field that should look like "5y3m".
I've made "Machine Age" unstored and I "Allow creation of records in this table via the relationship" but the table still has 0 records.
How do I trigger the population of that table? Do I have to loop through the main table with a script?
Or should I be changing it to a "One-to-one relationship" … can't find how.