I have a subform which is linked on ClientID = CLientID parent to child
There is another field visitID in both parent and child (visitID)
I need a link on parent and subform where the parent visitID = child.visitID OR a NULL value.
Heres the reason...
The child table is a contacts history table and can have replicated contact's because they will on multiple visits over the years