I have some forms with a lot of fields that pull-through from other tables.
I wanted to add these forms as a sub-table, showing just the few fields that need completing, and have people fill out the forms from the sub-table.
However, while that works, and it creates a new record etc, when I then go to the record it has created, none of the fields that are meant to have pulled-through have in fact done so. If I reinsert the fields that they are linked with then it all pulls-through correctly, but this is a duplication of my time as I have only just completed these fields back in the sub-table.
Is there a fix for this, or is there perhaps a “refresh” style button that could force these field to pull-through?