Filtering Records Based on Linked Child and Master Fields

[xcaliber2222]

Hello,

I have a parent and child subform which are linked by two values [TID2] and [BankDate]:

Link Child Fields: [TID2];BankDate
Link Master Fields: [TID2];BankDate

My understanding is that these two values form a unique composite key. However, it seems that records with a duplicate TID2 are not being filtered out. Is this a correct assumption?

Thanks,
Alejandro

 

[kjv1611]

Have you checked the table properties? That's where you'd verify your assumption about the composite key.