In its simplest form create 2 date fields in the parent table, store as Global fields. Your relationship would be
ParentID = ParentID
DateStart <= Date
EndDate >= Date
Thanks for the quick reply John.
I managed to get it to work using a separate table but sounds like using global fields may be the way to go.