Thanks for your post.
Unfortunately, SQL Data Generator doesn't support this sort of parent > child relationhip between columns when generating data. It is something we have logged as a feature request but I am sorry to say I am not sure if we have a date on it being implemented. It will definitely be reviewed for the next release though.
In the meantime, ?I don't know if it's a vible solution for you however you could always select to generate data from an existing source for that table (those affected tables) only, pull in the real data for those particular columns only and then change the generator to one of the random generators for the rest of the columns.
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569