Looking for a way to add entries to a subtable automatically based upon dynamic filter setttings applied to linked sheet. Currently the dynamic filtering can be used to show select records to choose from but requires selecting each individual record. This is slow and error prone as duplicate entries are allowed and only flagged when trying to save the record. Preferred action is to have the subtable entries auto added based upon the dynamic filter and automatically add to subtable.
How do you trigger the sync by CUD to the source of the subtable?