I want to use to specify a filter on the parent table in order to select the data to be included in the Foreign Key generator
Thank you for reaching out on the Redgate forums regarding your Data Generator foreign key question.
Are you able to provide some more details around your question, do you have an example of what you are trying to achieve.
What generator are you using - is the the Foreign Key (automatic) or Foreign Key (manual)? Can you send a screenshot of how you have it configured in the project?
I don't believe this is possible with the normal generators - You may need to use the SQL Statement or Python generators to get linked columns, but I'm too sure that would work with Foreign Keys.
If you can provide some more info on your desired outcome we can look at what may be possible
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal