update foreign key instead of related object when all PKs are set

plus have correct tests
plus have a changelog entry now

works with accessor single and filter