Thanks for your post. Unfortunately, it isn't possible to populate data for columns based on the sum of other columns, i.e. dictate a column relationship other than PK > FK.
We do however have this as an existing feature request in place of which I will add your request to, however I sorry to say that we don't have a timescale at the moment for if / when this feature is likely be implemented.
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569