Hello,

This question is more about Access ADP-s than about SQL Server. The
easiest way to solve this is to use another subform for the T2 table
(linked to the parent form by the MatDetId column, using
LinkChildFields/LinkMasterFields), so that each form is bound to
exactly one table. As long as you are not using datasheets (and since
we are talking about large notes, I suppose that datasheets are out of
the question), you can use a subform with a transparent border so the
user won't even notice that there is a subform.

Razvan