1 of 1 people found this helpful
If the mock-up reflects the original,
one could restore an automatic blend
by making changes as follows:
1) In the Secondary : make [Period] a Date Type (it is Date & time currently).
2) In the Secondary: copy [Period] to a new field named [Order Date]
3) Restore blend to be Automatic (not Custom as currently set).
4) In the Secondary : Enable blend by [Order Date] and [Region].
5) Save & publish. Then download & check if broken. Hope it's not.
Thanks for your efforts it was a bad mock-up as the fields are set to the correct data types; everything is setup as expected though the custom blend is needed (I forget why now it has been two months since I last checked - shall try to remember why and update), but either way, the custom blend is required and I suspect this is the reason for the blend connection to break on update.